| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
