Is there a way in 'Excel 2000' to reverse the order of a column from bottom to top?
C Carl Jaeger Jan 29, 2004 #1 Is there a way in 'Excel 2000' to reverse the order of a column from bottom to top?
F Frank Kabel Jan 29, 2004 #2 Hi Carl one way without macros: use a helper column (lets say column B). In B1 enter the following formula =OFFSET($A$100,1-ROW(),0) copy down Afterwards copy column B and with 'Paste Special - Values' paste in column A HTH Frank
Hi Carl one way without macros: use a helper column (lets say column B). In B1 enter the following formula =OFFSET($A$100,1-ROW(),0) copy down Afterwards copy column B and with 'Paste Special - Values' paste in column A HTH Frank
K Ken Wright Jan 29, 2004 #3 With your data in A1:A100, in B1 put 1 and then filldown to B100, eg 1,2,3,4,5 Then select all data and sort on col B in descending order. Then just blitz B.
With your data in A1:A100, in B1 put 1 and then filldown to B100, eg 1,2,3,4,5 Then select all data and sort on col B in descending order. Then just blitz B.
