Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / January 2008

Tip: Looking for answers? Try searching our database.

Sorting Negative with Positive Values

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chris - 31 Jan 2008 19:21 GMT
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
Mike H - 31 Jan 2008 19:38 GMT
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

> How would you sort the following matching absolute values to look like it
> does in the "After" view?
[quoted text clipped - 16 lines]
>
> Thanks, Chris
Chris - 31 Jan 2008 20:59 GMT
Fantastic Mike - thanks for the help,

Chris

> Chris,
>
[quoted text clipped - 28 lines]
> >
> > Thanks, Chris
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.