want to flip data in an excel column so last is first, first is l.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data in a list/column that I'd like to have listed in reverse order,
i.e. the list appears with the last item from the initial list first and the
first item from the initial list last. Does anyone know of a way to do this?
Thanks.
 
~Insert a column: call it Column A
~Go to the last item in the list, and enter 1 in the new column next to
the last entry: suppose that's cell A50
~In the cell immediately above the 1, or A49, enter the formula =A50+1.
Copy that formula up to the first entry.
~Sort Column A (ascending) over your range of rows
~Delete column A

Vwala!
 
Hi!

If you have 50 such items in column A1:A50, put
=INDIRECT("A" & 51-ROW())
in B1 and copy down to B50.

Alf
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I separate first and last names into two columns? 2
Search two columns in list for first and last name and return Id 4
Reversing Last Name and First Names 2
reformat a cell from last name, first to first space last? 5
How do I reverse name order from Last, First to First Last in Exc 3
VBA - retrieve data on last create named range from previous inserted named range 0
LAST, FIRST to First Last 4
Separate First, Last Names 2

Back
Top