Forum Discussion
comparing cell values to determine which is highest, then returning the name assocaited with it
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.
OK the 1000 rules also needs to be in part 2, I didn't know. Find attached the new version.
If this is anything close to the result you would like to have maybe you can try to do the finetuning of the formulare yourself
- Hi,
Its still showing no winner if yellow is below 1000. I've looked at your formula, and to be honest, I don't know where to start to adjust it!