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)

--

Regards,

Peo Sjoblom

"Dave F" wrote in message
ups.com...
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?