Data to another sheet

  • Thread starter Thread starter nandu1256
  • Start date Start date
N

nandu1256

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?
 
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to finding student Rank and How to upload bulk marks of each student at a time. 1
Sorting Data from a different sheet 1
copying data to summary sheet 2
Retrieving values from another sheet 1
Copy data to different sheets 6
USe Contents of cell as name of worksheet in a function 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Drop Downs and lookups from other sheets 2

Back
Top