Thread: Reverse Order
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default 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