P PL Jul 1, 2009 #1 I have a row of data that I would like to reverse the order, how do I do so? Eg A B C I want C B A Thank you
I have a row of data that I would like to reverse the order, how do I do so? Eg A B C I want C B A Thank you
S Sheeloo Jul 1, 2009 #2 Assuming your data is in Row 1 then enter this in B1 and copy across to B2,... =INDIRECT("R1C"&(7-COLUMN()),FALSE) replace 7 by the column number of the last column with your data (A=1, B=2, Z=26)... You can then copy and paste special as values...
Assuming your data is in Row 1 then enter this in B1 and copy across to B2,... =INDIRECT("R1C"&(7-COLUMN()),FALSE) replace 7 by the column number of the last column with your data (A=1, B=2, Z=26)... You can then copy and paste special as values...
P Per Jessen Jul 1, 2009 #3 Select the row, and goto Data > Sort > Options > Select "Sort left to right" > Ok > Descending > OK Regards, Per
Select the row, and goto Data > Sort > Options > Select "Sort left to right" > Ok > Descending > OK Regards, Per
J Jacob Skaria Jul 1, 2009 #4 Try the below formula and copy that to right cells as required. =INDEX($A$1:$J$1,,COLUMNS($A$1:$J$1)-COLUMN(A$1)+1) If this post helps click Yes
Try the below formula and copy that to right cells as required. =INDEX($A$1:$J$1,,COLUMNS($A$1:$J$1)-COLUMN(A$1)+1) If this post helps click Yes
