How do I reverse a row in Excel? (1-10) - (10-1)
 

How do I reverse a row in Excel? (1-10) - (10-1)
 

You could use Data | Sort
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jh" wrote in message
...

How do I reverse a row in Excel? (1-10) - (10-1)
 

Assuming your data is in D2:D16,
=INDEX(D$2:D$16,ROWS(D$2:D$16)-(ROW()-ROW(D$2)))

HTH
--
AP

"jh" a écrit dans le message de news:
...