LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default Return the data from 3 columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup to return 2 columns oldLearner57 Excel Discussion (Misc queries) 5 May 13th 07 03:15 AM
Match two columns, return a third piece of data uncreative Excel Discussion (Misc queries) 2 April 25th 07 12:40 AM
Match data in 2 columns and return data from 3rd column gwtreece[_2_] Excel Worksheet Functions 1 April 4th 07 03:27 PM
If value in data range (multiple columns) return row flickflick Excel Discussion (Misc queries) 0 August 18th 06 11:59 AM
return data in multiple columns using "if"? JENNYC Excel Discussion (Misc queries) 3 November 7th 05 07:25 PM


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"