Which formular should be

Dear all,
I have a range of data, like
A1=1
A2=2
A3=3
A4=5
A5=9
Which formular should be in column B to get the data from column A but in opposite order:
B1=9
B2=5
B3=3
B4=2
B5=1
Thanks for your help.

Thank you. It can be work, but just ok with sequent order number. I tried with B1=INDEX(A$1:A$5,ROWS(A$1:A$5)+1-ROW(3:3)) and copied down. It works.

try the following in B1

=INDEX($A$1:$A$10,COUNT(A1:$A$10)) and copy down