Thread: Reverse Order
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PL PL is offline
external usenet poster
 
Posts: 58
Default Reverse Order

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