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

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

Thank you Sir

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

I will give that a try mrice, thank you!