excel sorting functions

C

Crash

I have an excel spreadsheet which includes a number column of percentages. I
would like to sort it in descending order and can do so, but then I am not
able to unsort it back to original order. Does anyone know the way to go
about this?
Thanks
 
R

RagDyer

Insert a "helper" column next to the percent column, and number the rows
from 1 to whatever.
Include this helper column in your data range when you perform your original
sort.

When you're ready to return to the original order, simply use this helper
column as the sort key.
 

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

Auto sort help. 2
Cells are not sorting correctly 2
Sorting failure 2
Rank order with conditions 3
Pivot Table Sorting 6
Function in Excel to count and list number of entries of text valuesin a row. 2
writing a sort function? 0
Changing the sorting order... 5

Top