Data to another sheet

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

Jacob Skaria

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

Crating User Form to Add Names 1
Publisher is filling blank lines with data 2
Grouping Names in Mail Merge 0
trouble with (complicated) vlookup searching another workbook 2
Two columns : Continuous two columns vs Parallel two Column 1
Treating multiple paragraphs as one 2
Dealing with a Pivot Table (when I don't want to) 0
Cell data entering slow! 0

Top