An eg of what I have, with each number in their own cells

1 3 2

I want to copy & paste this row of numbers in reverse order, but not sort
descending or ascending

2 3 1

I tried the formula
=INDEX($A$1:$K$1,COUNTA(A1:$K$1))

but it doesn't work. What's wrong with it?

Thank you

Per your example data................

With numbers in A1:C1 enter in A2 and copy across to C2

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


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 17:12:01 -0700, PL wrote:

An eg of what I have, with each number in their own cells

1 3 2

I want to copy & paste this row of numbers in reverse order, but not sort
descending or ascending

2 3 1

I tried the formula
=INDEX($A$1:$K$1,COUNTA(A1:$K$1))

but it doesn't work. What's wrong with it?

Thank you