Reverse Order
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 |
Reverse Order
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... "PL" wrote: 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 |
Reverse Order
Select the row, and goto Data Sort Options Select "Sort left to
right" Ok Descending OK Regards, Per On 1 Jul., 05:46, PL wrote: 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 |
Reverse Order
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 --------------- Jacob Skaria "PL" wrote: 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 |
All times are GMT +1. The time now is 07:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com