View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default 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:
...