Link to home
Start Free TrialLog in
Avatar of John Smith
John SmithFlag for Australia

asked on

Maximum / Lookup Formula Question

Hi All,

I have been struggling with this one!  

I  need a formula which looks up the maximum value in column A for each unique number in column B and puts the text "end" in column C.  please see working where I have manually entered "end" where I want it.  All other cells in column C should be blank.

Thanks!
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Did you manage to upload something?
Avatar of John Smith

ASKER

Put this formula in C3 and copy down

=IF(B3<>B4,"end","")
That does work, however I need something a bit more robust as the data might not be in order.
Just show me a sample please.
Attached has data not in order.
Experts-Exchange-v2.xlsx
You did not show the desired results.
Sorry! try again!
Experts-Exchange-v3.xlsx
This is an ARRAY formula and must be entered using ctrl-shift-enter

=IF(B3=MAX(IF($C$3:$C$10000=C3,$B$3:$B$10000)),"end","")
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial