Here's my situation:
Column A contains identifiers
Column B contains values
Column D is blank (will have corresponding identifier to column E)
Column E is the largest value (i'm using the large function to give me top 10 values)
What do i put in column D?
Hi,
Try this
=INDEX($A$1:$A$10,MATCH(E1,$B$1:$B$10,0)) adjust range to suit
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks