reverse order of numbers

  • Thread starter Thread starter Dave F
  • Start date Start date
D

Dave F

Assume I have the following values in the range A1:C1:
1 | 2 | 3

Is there a formula I can use in A3:C3 that would reverse this order;
i.e., 3 | 2 | 1

Or is this best done in VBA?
 
If you put this in A3 and copy across

=INDEX($A$1:$C$1,COLUMNS($A$1:$C$1)+1-COLUMNS($A$1:A1))

note that the last occurrence of COLUMNS should always refer to $A$1:A1 in
the first cell

you can get a shorter formula using offset and column but that would be
volatile (offset that is)
 
A small suggestion to remove the hardcoded 3:
=INDEX($A1:$C1,COLUMNS(A1:$C1))
copied across.
 
I presume all the suggested formulas were posted with an eye that the OP
will be using more than 3 columns; however, if the OP's posting was really
all he wanted, then I think this might be easier. Place these formulas in
the indicated cells...

A3: =C1
B3: =B1
C3: =A1

<g>

Rick
 
I will be using 15 columns. The three columns given were an example.

Thanks to all for your responses.

Dave
 
Back
Top