Hi There -
I have a need to find the highest value in Column B based on the unique identifier in Column A.
For instance, in my attached example, the formula should place "Highest" in Column C for "ARE" next to 45.
Thank you!
Hi There -
I have a need to find the highest value in Column B based on the unique identifier in Column A.
For instance, in my attached example, the formula should place "Highest" in Column C for "ARE" next to 45.
Thank you!
Enter formula to get unique list from Col A
Enter in D4 and copy down
Formula:Please Login or Register to view this content.
then enter in E4 and copy down
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi -
Doesn't seem to work. When I copy down D4 it says "ARE" in every cell and E4 is saying there is a circular reference...
Also, what is "zzz"?
In C4:
=IF(B4=MAX(IF($A$4:$A$286=A4,$B$4:$B$286)),"Highest","")
... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Once confirmed, drag copy down.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you so much! Works like a charm!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks