Returning the Name with lowest Sales
I have a list of salespersons (Col. A) with their quarterly sales numbers in Col. B. I use the MIN function to return the lowest sales number for the quarter. How can I retrieve the name associated with the smalles sales number from the list? Can I do this without sorting my list?
Thanks,
Ormond
Last edited by Ormond2009; 08-08-2011 at 09:36 PM.
=INDEX(A:A,MATCH(MIN(B:B),B:B,0))
Does that work for you? If there is a tie, it will only pull the first one.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you! I set the ranges of the fields and it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks