last 4 & 5 numbers

[louis128]

hi to all,what i needed is a formula at at B1:B4 which looks the last four numbers in the A:A column and at C1:C5 a formula which looks the last five numbers of column A:A.
thanks for help guys!

[louis128]

here i've attached a workbook

[PaulM100]

Maybe something like this. Drag it as many rows as you need:
=INDEX(A:A, MATCH(1E+99, A:A)-(ROW(1:1)-1))

[louis128]

great!i put the formula at E1 ,but i need the numbers in order not to mirror them.thank you so much

[louis128]

finally, it does not make any difference!thanks alot!