picking the contents of one cell if another cell meets criteria

**gsloman** · 09-25-2011, 11:01 AM

hi folks - i hope someone can help

i've got a list of names and each one has a score - once i've identified the top scorer i want to be able to get their name appearing in another worksheet as top scorer - so if names are in column A and scores are in column G, once the highest score has been identified, i want to be able to take the name of the highest scorer from A and get it to appear in another worksheet - is it possible?

**daddylonglegs** · 09-25-2011, 11:13 AM

You can get the first top scorer in the list with a formula like this

=INDEX(A:A,MATCH(MAX(G:G),G:G,0))

but how do you want to proceed if there are joint top scorers, do you need to list all of them?

**gsloman** · 09-25-2011, 11:18 AM

Thanks that works - you're a star! but Yes I'd need to list them all if there was atie

**gsloman** · 09-25-2011, 01:56 PM

Thanks - could you tell me what does the 0 do at the end of your =INDEX(A3:A23,MATCH(MAX(G3:G23),G3:G23,0)) ? I'm trying to see if anything different at the end might show uip two names when they tie as high scorers

Thread: picking the contents of one cell if another cell meets criteria

Thread Tools

Display

picking the contents of one cell if another cell meets criteria

Re: picking the contents of one cell if another cell meets criteria

Re: picking the contents of one cell if another cell meets criteria

Re: picking the contents of one cell if another cell meets criteria

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions