D
duane
try inserting a new column and filling it from 1 to whatever and the
sort based on the new colum
sort based on the new colum
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jack Sons
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
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
H
harryhill
Have you tried: Zto A sort
H
Howard Roberts
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.