ExcelBanter - how do I invert the order of items in a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I invert the order of items in a column (https://www.excelbanter.com/excel-discussion-misc-queries/209136-re-how-do-i-invert-order-items-column.html)

Howard Roberts

how do I invert the order of items in a column

"Jack Sons" wrote:

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

"Ron G" <Ron schreef in bericht
...

Jack, your a genius. Thanks.

All times are GMT +1. The time now is 12:09 AM.