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.

Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Did you manage to upload something?
Avatar of John Smith


Put this formula in C3 and copy down

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.
You did not show the desired results.
Sorry! try again!
This is an ARRAY formula and must be entered using ctrl-shift-enter

Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

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