Extract the largest number

**YasserKhalil** · 12-06-2014, 02:49 AM

Hello everybody
I have some tables with names ans marks.. I want to extract the largest mark and the name for every table
I have an attachment with the expected results in column D & E
Thanks advanced

**Crooza** · 12-06-2014, 03:10 AM

Try this in E2 you can work the others out)

=MAX(IF(A4:A23=D2,B4:B23))

put in as an array formula (shift+control+enter)

**YasserKhalil** · 12-06-2014, 03:23 AM

Thanks sir
I attached the results ..
I want to extract the name and mark for each table .. I have a lot of tables .. this is just a sample
I need to create results in Column D and E..Basically D and E have no values at all

**Crooza** · 12-06-2014, 03:35 AM

Just change the formula to suit

=MAX(IF(A4:A23=D2,B4:B23))

The D2 above is the letter (A,K or S) you're checking for if you use the exact same formula in the rest of your E column and only change this part of the formula you'll be right.

OR why don't you set up a pivot table returning each name and the maximum value