Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel sorting functions
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel sorting functions
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. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Crash" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel sorting functions
Hi,
You could also have another column which holds the sorted data and updates automatically if the unsorted data changes. Assuming your unsorted data is in A2:A21, in B1 enter =LARGE($A$1:$A$21,ROW() -1) and copy down. Dave url:http://www.ureader.com/msg/104233702.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
How to use functions after sorting a range? | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |