在Ms Excel中进行底向上引用。

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

我正在为考试安排座位。小型张1 - A1:A5(包括滚动编号)

1
2
3
4
5

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

我想要在Sheet2自下而上的参考从另一个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.

我1。在Sheet2 A5 =Sheet1:A1 2。在Sheet2 A4 =Sheet1:A2 3。在选择这两个单元后拖拽。

This is not working.

这不是工作。

1 个解决方案

#1

Put following formula to Sheet2 A1 cell then drag and down

将以下公式放入Sheet2 A1单元，然后拖放

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