| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. | Excel Worksheet Functions | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| Hyperlinking from data in one sheet to matching data in another sheet | Excel Worksheet Functions | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Hybrid Mode
