ExcelBanter - Data to another sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data to another sheet (https://www.excelbanter.com/excel-worksheet-functions/258267-data-another-sheet.html)

nandu1256

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?

Jacob Skaria

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?

All times are GMT +1. The time now is 12:47 PM.