Reverse order using formula

hi friends,,,

please solve this..
Display in reverse order using formula
Answer:
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

You asked this in your previous thread - see the answer there.

Pete

=INDEX($A$1:$A$12,12-ROWS($1:1)+1)

its working for first cell only..
remaining is #ref!

yes this formula is working...
just i copied and pasted in one new sheet .. its working
but my cell count is start at 60th cell ...if using this at 60th cell its working but not for 61th cell.
bcoz its its taking the formula as --------rows(1:$60) .. why its coming like this....

I assumed that your months began in cell A1. If they start in cell A60, then the formula in B60 should be:

=INDEX($A$60:$A$71,12-ROWS($1:1)+1)

then copy that down to B71.

Hope this helps.

Pete

thank a lot friend... i got it...

Then please mark the thread (and your others) as solved, as I indicated to you earlier.

Pete