| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort a range of cells via a worksheet function
I have one column of unsorted cells. I want to create a second column with the sorted values from the first column. I can easily copy/paste the first column and then manually use the sort menu command. But I want to do that via a worksheet function so that when I change the unsorted values in the first column, the sorted column automatically updates. Make sense? I need to keep both the unsorted and sorted versions of the same data. -- RogerWilco ------------------------------------------------------------------------ RogerWilco's Profile: http://www.excelforum.com/member.php...o&userid=18906 View this thread: http://www.excelforum.com/showthread...hreadid=499625 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| total a range of cells in Excel into a different worksheet | Excel Worksheet Functions | |||
| subtotal a range of cells on a different worksheet | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Sorting a range of cells that get value from other cells | Excel Discussion (Misc queries) | |||
| How to paste INDIRECT function to range of cells? | Excel Worksheet Functions | |||
Threaded Mode
