Forum Discussion
comparing cell values to determine which is highest, then returning the name assocaited with it
Hi
Please take a look at attached file which hopefully covers both cases (part 1 and part 2).
https://kteamch-my.sharepoint.com/:x:/g/personal/pascal_kiefer_kteam_ch/ERyix6L1a2BOr74NSmaZxjABlX0mzT_DpgSZEaF2uCcF9A?e=0ufQlc&Download=1
Let me know if this solved the issue or if I misunderstood your requirement
Hey, and thanks for helping me on this problem.
I think its almost correct, however, every other cell under E is empty?
i thought part 2 was only for rows which are marked with "1". But then it's the same for the rows with "2". Check out the new file and see if it works
Couple observations. I changed the first set to below 1000 each, and yet yellow is showing as the winner still in part 2 rather than no winner. Also, how would the formula look to show the opposite, ie the lowest?
In application, I will be looking to put this across maybe 100 different inputs (blue, yellow, etc) and I'm essentially looking for the highest colour from 1000 and the lowest colour from 1000.
