I have attempted several functions Vlookup+IF, index/match. To complete step 1 in manipulating the given data for my purposes.
Sample data:
I no longer have the program that allows you to post excel data in a neat format to a forum post, nor could I find a reference in search. If someone could let me know, I can post data and desired solution.
Thanks in advance.
Sample data:
I no longer have the program that allows you to post excel data in a neat format to a forum post, nor could I find a reference in search. If someone could let me know, I can post data and desired solution.
Thanks in advance.