how do I invert the order of items in a column

  • Thread starter Thread starter Guest
  • Start date Start date
try inserting a new column and filling it from 1 to whatever and the
sort based on the new colum
 
Ron,

Once I got this from Alan Beban:

=OFFSET($A$1,COUNTA(A:A)-ROW(),0) will work if your data always starts in
$a$1 if it starts in say row 14 then =OFFSET($A$1,COUNTA(A:A)+14-ROW(),0)
will work. if there is other information in column A you would have to
specify the range in the Counta function.


Jack Sons
The Netherlands
 
Jack Sons said:
Ron,

Once I got this from Alan Beban:

=OFFSET($A$1,COUNTA(A:A)-ROW(),0) will work if your data always starts in
$a$1 if it starts in say row 14 then =OFFSET($A$1,COUNTA(A:A)+14-ROW(),0)
will work. if there is other information in column A you would have to
specify the range in the Counta function.


Jack Sons
The Netherlands



Jack, your a genius. Thanks.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to invert Cols/Rows? 2
How to invert column entries in Excel 1
Inverting sign 4
how do I invert the order of items in a column 3
how do u reorder data in a column so last cell entry is first? 7
Invert a column of data. 4
How do i invert text in Excel 3
invert Lines and column on Excel 3

Back
Top