Thread: How to reverse data of a single column?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default How to reverse data of a single column?
On Thu, 27 Aug 2009 06:10:02 -0700, Denish D <Denish
wrote:

How to reverse data of a single column?

Example:


Column

2254
245
148
224
2515
8476
47
5647
.
.
.
.
.
.
.


My question is " what to do if i want to these column values as shown below :

.
.
.
.
.
.
5647
47
8476
2515
224
148
245
2254

please reply..


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

where "rng" is the named range where your data exists.

Fill down until getting blanks.
--ron
Reply With QuoteReply With Quote