I have 32 combinations of variables which can be chosen. Depending upon the combination selected, a Mark of "X" or "Optional" will appear in the cell of 1 to 7 levels. Sounds more complicated than it really is. I have mapped out the combinations and the output I desire. I just don't know how to construct the right formula. The end product would have a single line. In the "green" columns, the user would select one of the variables in three categories (Category 1 - Mandatory or Optional; Category 2 - Awareness, comprehension, Commitment, Action, and Category 3 - Global, Regional/Affiliate, Ecosystem, Individual.
10 freelancer đang chào giá trung bình $21 cho công việc này
Your project simply requires figuring out the logical formula(If don't already have it) and implementing it using excel functions. Depending on the details you provide I can finish your project quickly.
Hi, I have done data manipulation in excel & can do this task by writing the required formulas. Let me know if you want to discuss further. Regards, Monir
Good afternoon, I would like to help you and I can do it without problem, you just have to use the conditional if and search functions. I am at your command