Forum Discussion
comparing cell values to determine which is highest, then returning the name assocaited with it
Both scenarios of part 1 are done and attached in sample file for your reference. Please let me know if it works as desired .
Please elaborate more the second part of your requirement, for example what criteria you need for D3, D5 or D6.
Thanks
Tauqeer
Hey, Thanks for taking the time to look at this, for me.
I'm not sure your solution is correct. I changed the blue to a lower value than the yellow, and it returned no winner each time, instead of yellow
As for part 2, it is essentially the same problem, however it is looking at an aggregate of numbers, rather than just one number to compare. To reword it, instead of 1,2 lets call them Q1, Q2, Q3, Q4 of a year for example. I want to look at what the average 'Blue' number was in say 'Q1' going back in time, and compare that against its 'Yellow' counterpart to determine which is higher/lower.
So in the image above, I've highlighted Q1 for the sake of ease. so in cell D1, it would just be the winner between B2 and C2, which is Blue (and loser in the opposite condition). when we get to cell D6, it would then be the mean average of B2 and B6 vs the mean average of C2 and C6. Then in cell D10, it would be the average of B2, B6 and B10, vs C2, C6, C10 ad nauseam.
Do let me know if that makes more sense, and thanks again for your time on this!
Hi kemble999
As far as the first part is concerned it is showing 'no winner' in all cases because of the below condition that you mentioned in in your first post,
'the minimum 'winner' would need to be above the number 1000. If below then return something like, "no winner"
If you simply input 1001, it will show Yellow as winner
Thanks
- Ah, I think there has been a misunderstanding. The winning entry so to speak must be above the 1000 mark to be the winner, but what its comparing against could very well be below 1000
In general, better if you attach your sample file to the post together with screenshorts - you'll save time for the people who are answering on generating new test file copying your data from the screen into Excel sheet.
- Noted, Thanks
