Try the below formula and copy down as required

=INDEX($A$1:$A$7,ROWS($A$1:$A$7)-ROW(A1)+1)

--
Jacob (MVP - Excel)


"Denish D" wrote:

I have values in a column like:

546
3242
54
5645
257
245
1565


i Want to make them in reverse order as :

1565
245
257
5645
54
3242
546

Can any one help me...