invert data in xls file

P

pepene

Hello

I have a question hou to invert data in a xls file
I have a file with 3000 lines with number data and i want to change i
a file where the line 3000 to be 1, 2999 to be 2, 2998 to be 3, ....
I need help pls !!!

Thank you in advanc
 
J

Jay

I have a question hou to invert data in a xls file
I have a file with 3000 lines with number data and i want to change in
a file where the line 3000 to be 1, 2999 to be 2, 2998 to be 3, ....
Click to expand...

One way:

1. Find an unused column, say "U", and put the following in U1:
=5000-ROW()

2. Extend U1 downward for as many rows as you need.

3. Select the entire sheet, and use:
Data >> Sort >> Sort by >> Column U >> Ascending

4. Delete the values in Column U.
 
G

Gord Dibben

In an adjacent column in cell1 enter a 1, in cell2 enter a 2

Select both cells and double-click on fill handle(black lump at lower right
corner)

This will give you 1 to 3000 in the column.

Select all columns and Data>Sort.

Sort descending by that helper column.

When happy with the inversion, delete the helper column.

Gord Dibben Excel MVP
 
Top