Data is in B:C, B text data, C numerical data
I want in E:F, in E Unique from B (I have it already) and F I want corresponded MAX value from B
I have in F how should be
Answer please at F2
Data is in B:C, B text data, C numerical data
I want in E:F, in E Unique from B (I have it already) and F I want corresponded MAX value from B
I have in F how should be
Answer please at F2
In F2:
=AGGREGATE(14,6,$C$2:$C$19/($B$2:$B$19=E2),1)
Copy down.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thank you so much, simple answer, .....I need to learn Excel...
You are welcome and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks