inverting data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

I Maycotte - 10 Jul 2006 14:45 GMT

I'm wondering if it's possible to invert data so that what is up at th
top will now be at the bottom and what is at the bottom will now be u
at the top. This would be easy if I had only a few rows o
information, but I have hundreds. Thanks in advance.

-- Isaa

Reply to this Message

RagDyeR - 10 Jul 2006 15:26 GMT

You can temporarily add a 'helper' column next to your column of data, and
then number it from 1 to whatever.
Select both columns and sort on the 'helper' in descending order.

Signature

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I'm wondering if it's possible to invert data so that what is up at the
top will now be at the bottom and what is at the bottom will now be up
at the top. This would be easy if I had only a few rows of
information, but I have hundreds. Thanks in advance.

-- Isaac

Signature

I Maycotte
------------------------------------------------------------------------
I Maycotte's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=35604
View this thread: http://www.excelforum.com/showthread.php?threadid=559888

Reply to this Message