Thread
:
how do you invert a column
View Single Post
#
4
Posted to microsoft.public.excel.misc
Toppers
external usenet poster
Posts: 4,339
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
Reply With Quote
Toppers
View Public Profile
Find all posts by Toppers