View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default how do you invert a column

Assuming data in column starting row 2, and with no embedded blanks, then in
B2 put:

=INDIRECT("A" & COUNTA(A:A)+2-ROW())

HTH

"Chris" wrote:

0
1
2
3
4
5

I would like

5
4
3
2
1
0