Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Help please
I have a spread sheet that records amonst other stuff scores, what I'm after is something that will review the data in column P3 down to P220 choose the 10 highest I then want it to pick up the name from the corresponding line held in column A 3 down to A220 and also to return the same from column B3 down to B220 the result needs to be placed in a new tab and be displayed over 3 cells by 10 rows Name Year points 1 shane 2007 500 2 peter 2007 400 3 shane 2006 385 4 paul 2007 368 5 peter 2005 300 6 roger 2006 298 7 steve 2007 287 8 fred 2005 251 9 shane 2005 232 10 harry 2007 221 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup to return 2 columns | Excel Discussion (Misc queries) | |||
Match two columns, return a third piece of data | Excel Discussion (Misc queries) | |||
Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
If value in data range (multiple columns) return row | Excel Discussion (Misc queries) | |||
return data in multiple columns using "if"? | Excel Discussion (Misc queries) |