I have a spreadsheet, where I am trying to compare 7 different values (non-sequential) and return the description of the one with the highest value.
This is what I'm working with:
I'm trying to compare the values in F19, F30, F35, F36, K15, and K22. Which ever one has the highest value, I want it to return the description of that one. For instance, in this case, I would want it to return "Impress Distribute & Automate Subscription). If there is no higher value (i.e. they are all $0), then just return a blank space.
Is this doable?
This is what I'm working with:
I'm trying to compare the values in F19, F30, F35, F36, K15, and K22. Which ever one has the highest value, I want it to return the description of that one. For instance, in this case, I would want it to return "Impress Distribute & Automate Subscription). If there is no higher value (i.e. they are all $0), then just return a blank space.
Is this doable?