Search code examples
excelexcel-formulaexcel-2007

Bottom Up reference in Ms Excel

I'm doing seating arrangement for an exam.
Sheet1 - A1:A5 (Contains Roll numbers)

1
2
3
4
5


I want this in Sheet2 Bottom up reference from another sheet
Sheet2 - A1:15

5
4
3
2
1

I did This
1. In Sheet2 A5 =Sheet1:A1
2. In Sheet2 A4 =Sheet1:A2
3. Dragged up after selecting these two cells.

This is not working.

Solution

  • Put following formula to Sheet2 A1 cell then drag and down

    =LARGE(Sheet1!$A$1:$A$5,ROW(1:1))