# sorting by 3 columns isn't working

#### scorpweb

##### Board Regular
hey all,
i have some data i need to filter in 3 fields but can't get it to work hope somone can help in someway or suggest a work around in some way
data is similar to
Subject 1 .......1/9/14......42
Subject 2 ........2/9/14.....32
Subject 1.........1/9/14.....56
I need it filtered so it has subject by date and the hours field (col C) organised by highest to lowest.
Subject 1.....1/9/14....56
Subject 1.....1/9/14.....42
Subject 2 .....2/9/14.....32
above is an example of the desired outcome
any ideas would be great it's given me such a headache today.
...yes i've obviously tried the sort method in Excel

note: what appears to be Col, A,B,C above is really E,K,M if that makes a difference.

I'd welcome a work around as am totally lost on getting this working.

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Welcome to MrExcel. What version of Excel are you using?

...yes i've obviously tried the sort method in Excel

note: what appears to be Col, A,B,C above is really E,K,M if that makes a difference.

Can you better explain exactly what happens when you tried the sort method? Did it sort partially? How did you set up the sort?

I would think it should work. It did for me using your example data.

When using the sort method, make sure the subject text doesn't have hidden trialing spaces e.g.; "Subject 1" is not the same as "Subject 1 "

In excel 2010 this is what it will sort like if you select ... Data > Sort>

1) Sort by Subject > Sort on Values > A-Z
2) Sort by Date > Sort on Values > Oldest to newest
3) Sort by Hours > Sort on Values > Largest to smallest
Select OK

Hope that helps.

******** language="JavaScript" ************************************************************************>
Book1
ABCD
1SubjectDateHours
2Subject101/09/1456
3Subject101/09/1442
4Subject202/09/1432
Sheet1

thanks for the help all,

will try the above and check the leading spaces feel that may be the issue.

Replies
5
Views
376
Replies
3
Views
247
Replies
4
Views
1K
Replies
42
Views
4K
Replies
7
Views
307

Threads
1,196,391
Messages
6,015,010
Members
441,865
Latest member
Enragedpanda

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back