Thread: Is there an formula to reverse the order of a number sequence?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Is there an formula to reverse the order of a number sequence?
On Tue, 31 Oct 2006 19:22:01 -0800,
wrote:

Where is the number sequence located?
In a cell?
In a range of rows?
In a column?

How do you want the reversed sequence outputted?
In a cell?
In a range of rows?
In a range of columns?
In a text box?

If they are in a column, and you want them listed in another column in reverse
order, then

=INDEX(rng,COUNT(rng)+1-ROWS($1:1))

and drag down as far as necessary.
--ron
Reply With QuoteReply With Quote