Sort using more than 3 conditions?

[rami]

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

 

[kkknie]

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

 

[Tom Urtis]

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

Keyword: sort
Sub-topic: Sort a range
Item: Sort rows by four criteria (columns)

 

[nbrcrunch]

http://support.microsoft.com/?kbid=268007

http://techrepublic.com.com/5100-6270-1032683.html

 

[rami]

You guys are great. Thanks.