| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Negative with Positive Values
Fantastic Mike - thanks for the help,
Chris "Mike H" wrote: Chris, I ahve assumed you have 3 columns of data A1 to C14 In a helper column (say D)type =Abs(c1) and drag down Select the 4 columns of data and sort by column D ascending and a secondry sort of column B descending delete the helper column Mike "Chris" wrote: How would you sort the following matching absolute values to look like it does in the "After" view? Before After Record 1 6 Record 9 -2 Record 2 5 Record 6 2 Record 3 8 Record 12 -4 Record 4 4 Record 4 4 Record 5 9 Record 14 -5 Record 6 2 Record 2 5 Record 7 7 Record 11 -6 Record 8 -8 Record 1 6 Record 9 -2 Record 13 -7 Record 10 -9 Record 7 7 Record 11 -6 Record 8 -8 Record 12 -4 Record 3 8 Record 13 -7 Record 10 -9 Record 14 -5 Record 5 9 Thanks, Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing positive values to negative | New Users to Excel | |||
| sorting/grouping positive and negative numbers | Excel Discussion (Misc queries) | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| ... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
| switching values from positive to negative | Excel Worksheet Functions | |||
Linear Mode
