| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Sort Help
Good morning. I'm trying to sort a range with the primary sort column
containing positive and negative numbers. The sort is Ascending; however, I want the Negative numbers to show at the end of the sort. I do not want to add another column as this is a very complex workbook. A workaround has been implemented by using the ABSOLUTE Function, but I want to be able to dispaly te negative numbers. Any advice will be appreciated. Thanks... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB Sort Help
Sort descending to place the negative numbers at the bottom.
Then sort the positive numbers (only) ascending. -- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "The Hawk"wrote in message Good morning. I'm trying to sort a range with the primary sort column containing positive and negative numbers. The sort is Ascending; however, I want the Negative numbers to show at the end of the sort. I do not want to add another column as this is a very complex workbook. A workaround has been implemented by using the ABSOLUTE Function, but I want to be able to dispaly te negative numbers. Any advice will be appreciated. Thanks... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB Sort Help
So why didn't I think of that?
Thanks, Jim... "Jim Cone" wrote: Sort descending to place the negative numbers at the bottom. Then sort the positive numbers (only) ascending. -- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "The Hawk"wrote in message Good morning. I'm trying to sort a range with the primary sort column containing positive and negative numbers. The sort is Ascending; however, I want the Negative numbers to show at the end of the sort. I do not want to add another column as this is a very complex workbook. A workaround has been implemented by using the ABSOLUTE Function, but I want to be able to dispaly te negative numbers. Any advice will be appreciated. Thanks... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
| sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
| Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| sort (on part of) string - originally posted under Tricky Sort | Excel Programming | |||
Hybrid Mode
