Extract/Pull-Out the Name that has higest number assgined.

[amanp786]

Hey guys, I have names of people with a number assigned to it. And I was to pull out the name that has the highest number.

Thanks Guys

[Ace_XL]

In C1

=IF(B1=MAX(INDEX(($A$1:$A$1000=A1)*$B$1:$B$1000,0)),"*","")

Copy down

[amanp786]

Thank you Sir

[mrice]

You can do this with a user defined function.

Please Login or Register  to view this content.

Open the VBA editor by hitting Alt F11.
Insert a new module with Insert - Module
Paste in the above function
Go back to the sheet by hitting Alt F11.

In a C1, enter =StarHighest($A$1:$A$17,A1,$B$1:$B$17) and drag down

Remember to save the workbook as a macro enabled workbook .xlsm

[amanp786]

I will give that a try mrice, thank you!