#1   Report Post  
Rob
 
Posts: n/a
Default Conditional Sorting

I am looking to do a descending sort based on two columns being the same.
Here is a simple example of what I want to do
Before Sort
After Sort
Column 1 Column 2 Column 1
Column 2
1 5 3
3
2 2 2
2
3 3 4
7
4 7 1
5

Where the two columns match, I want them sorted first descending then the
columns that dont match sorted descending. CAN ANYONE HELP??
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you don't get a good response, you may want to type in your data once more.

Rob wrote:

I am looking to do a descending sort based on two columns being the same.
Here is a simple example of what I want to do
Before Sort
After Sort
Column 1 Column 2 Column 1
Column 2
1 5 3
3
2 2 2
2
3 3 4
7
4 7 1
5

Where the two columns match, I want them sorted first descending then the
columns that dont match sorted descending. CAN ANYONE HELP??


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP & Conditional Formating Help. Excel'ed Failures Excel Discussion (Misc queries) 6 August 16th 05 04:46 PM
How do i create a conditional sum? tmiller708 Excel Worksheet Functions 2 May 5th 05 01:58 AM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 01:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 7th 04 11:02 PM


All times are GMT +1. The time now is 12:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"