Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In column P of my spreadsheet I have a series of values
which I would like to sort in descending order regardless of whether or not the number is a positive or a negative number. The sort must display the nubers as they originally appeared (i.e.with the negative attached if it is a negative number) so the following list of numbers: 2346.70 -8246.06 360.00 -100.00 -6140.00 would appear as follows: -8246.06 -6140.00 2346.70 360.00 -100 Is this possible ? The only other thing to mention is that Row A of my spreadsheet is populated with column headings. Thanks in advance. Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtracting positive amts from negative and positive from positive | Excel Worksheet Functions | |||
Sorting Negative with Positive Values | Excel Discussion (Misc queries) | |||
sorting/grouping positive and negative numbers | Excel Discussion (Misc queries) | |||
IF positive/If negative???? | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) |