|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 8th, 2010, 04:11 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data to another sheet
I have a table for marks of students. I have their ranking in the last col.
In the next sheet I have another table in which I want the names of the first three to come. Is there any method? 
|
|
#2
March 8th, 2010, 05:02 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data to another sheet
Hi Nandu
Assuming you have names in ColA and ranks in ColE try the below formula in Sheet2 and copy down to three cells. =INDEX(Sheet1!A:A,MATCH(ROW(A1),Sheet1!E:E,0)) -- Jacob "nandu1256" wrote: I have a table for marks of students. I have their ranking in the last col. In the next sheet I have another table in which I want the names of the first three to come. Is there any method?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
