Invert excel data
=INDEX(A:A,4-ROW())
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"PJ" wrote in message
...
Great function. If I want to invert just 3 numbers in the column and not
the whole A column how do I change the equation?
"Bob Phillips" wrote:
=IF(COUNTA(A:A)-ROW()+1<1,"",INDEX(A:A,COUNTA(A:A)-ROW()+1))
and copy down.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"PJ" wrote in message
...
How can I paste data in inverse column order. From col A to col B
Col A Col B Paste in B
1 4
2 3
3 2
4 1
|