| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data sorting formula
Is there a formula that can sort a range of data
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data sorting formula
Easy if there are no duplicates and the data is numeric. Say we have
un-sorted values in column A. In B1 enter: =SMALL(A:A,ROW()) and copy down -- Gary''s Student - gsnu200850 "nir020" wrote: Is there a formula that can sort a range of data |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data sorting formula
Gary thanks
But I have duplicates,k if there anything I can do "Gary''s Student" wrote: Easy if there are no duplicates and the data is numeric. Say we have un-sorted values in column A. In B1 enter: =SMALL(A:A,ROW()) and copy down -- Gary''s Student - gsnu200850 "nir020" wrote: Is there a formula that can sort a range of data |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula or macro needed for sorting complex data issue. | Excel Discussion (Misc queries) | |||
| Sorting data derived from formula | Excel Worksheet Functions | |||
| Formula won't adjust after sorting data | Excel Worksheet Functions | |||
| sorting data, formula contance | New Users to Excel | |||
| Sorting Data and Formula help... | Excel Discussion (Misc queries) | |||
Hybrid Mode
