Inverting a list in Excel

  • Thread starter Thread starter Brac
  • Start date Start date
B

Brac

I have a list, numerical or alphabetical, and it is in no
particular sorted order BUT I want it that way. Now what
I would like to do is invert the list of cells
vertically, so that if there are 25 items the first
column looks like this: "1,72,33,45,52....23,98" and the
second column looks like this "98,23,....,52,45,33,72,1"

HOW DO I ACCOMPLISH THIS TASK? (***Remember, I do NOT
want to sort the list.) I want to leave it as is and
just reverse the order of it. I want to do the same
thing with names as well. I cannot figure it out. If
someone knows, could you please tell me. Thank you.
 
Use a helper column next to your column......just number it sequentially and
then sort both columns using the helper column as the sort key and set for
decending and your list will "reverse".......

Vaya con Dios,
Chuck, CABGx3
 
Hi Chuck,

Coming in loud and clear!

Biff
-----Original Message-----
Use a helper column next to your column......just number it sequentially and
then sort both columns using the helper column as the sort key and set for
decending and your list will "reverse".......

Vaya con Dios,
Chuck, CABGx3





.
Click to expand...
 
If Your Numbers are in A6:A31, in Cell B6 enter
=OFFSET($A$6,COUNT(A6:$A$31)-1,0) and Copy down to B31.
HTH
 
Thanks for the comeback Biff.......I think it's setteling down now......not
100% back to the old, but a lot better than it was......at least now my
posts seem to be staying up on the board.......

It's 80 degrees here in beautiful St. Petersburg Florida.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top