reverse order of numbers

[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?

 

[Peo Sjoblom]

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)

 

[Ragdyer]

Another way:

=INDEX($A$1:$C$1,3-(COLUMN(A1)-1))

 

[Guest]

A small suggestion to remove the hardcoded 3:
=INDEX($A1:$C1,COLUMNS(A1:$C1))
copied across.

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Dave F]

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

Thanks to all for your responses.

Dave