Reversing the contents of a List without programming

  • Thread starter Thread starter Karl Espeland
  • Start date Start date
K

Karl Espeland

Hi,

I have a spread sheet with a set of values in a column. I need to represent
these values in the reverse order. (Think of data that first are
representeted in chronological order, but that needs to be represented in
reverse chronological order as well).

Is there a good way of achieving this whithout programming and without maual
sorting?

thanks and Merry Christmas
 
One way:

Assume your data is in column A, with no blank cells. Then enter

B1: =INDEX(A:A,COUNTA(A:A)-ROW()+1)

and copy down as far as the data in column A.
 
Hi
and another solution
in B1 enter 1, in B2 enter 2. Now select both cells and copy down for all
rows. After this sort your data with column B descending
 
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

Reversing a column 2
Drop Down List 2
Can users perform a reverse lookup 7
Finding the last entry in a column based on criteria 9
How to reverse data of a single column? 5
Excel function to reverse the order of rows in a spreadsheet 3
counting the occurrence of specific text within a date range 4
reverse contents of cell 11

Back
Top