Sort using more than 3 conditions?

R

rami

New Member
Joined
Apr 2, 2004
Messages
34
I am very close to getting where I need to be thanks to this board, but I am just one step away.

I have the following data:

Date, Remove, Site, Student, Code, E-Mail, Attended, Enrolled, Advertised

I would like to sort by 'Date','Code', 'Site', 'Student' - Is this possible, or am I limited to 3 conditions in sorting?

Thanks
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
I believe (but am not sure) that if you first sort by Student, then by Date, Code, Site you will get the results you want.

Give it a try. If it doesn't work, there's always the Undo button...

K
 
Upvote 0
You will find the answer in Excel's Help feature:

Keyword: sort
Sub-topic: Sort a range
Item: Sort rows by four criteria (columns)
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Solved
VBA: Advanced Filter Limitations
Replies
3
Views
619
zero269
Z
H
  • Solved
Create list of last(family) names when parents have children in more than 1 class
Replies
3
Views
100
Peter_SSs
Peter_SSs
D
  • Solved
Conditional Formatting Using VBA
2
Replies
15
Views
143
DanteAmor
DanteAmor
M
  • Solved
Condition formatting - count how many of the same color OR value appears in the list ?
Replies
5
Views
134
Asbestos_Jen
Asbestos_Jen
Keebler
  • Solved
clean code
5 6 7
Replies
66
Views
2K
Keebler
Keebler

Forum statistics

Threads
1,223,911
Messages
6,175,327
Members
452,635
Latest member
laura12345

Share this page

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

Which adblocker are you using?

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
Back
Top