sort by 4 criteria

[mattmattmatt]

I need to sort a list of data by 4 criteria. the sort method only allows upto 3 criteria. can anyone point me in a good direction please

[Bob Phillips]

Sort by the two least important criteria, then sort again by the two most importanyt criteria.

[mattmattmatt]

Thanks so much for your quick reply, but are you certain that works? I tried by 2,3,4 and then by 1 but results didnt look right .... will look again. thanks.

[Bob Phillips]

It is what I always do.

I am not sure what your example meant, but you have to have all of the data selected for both sorts.

[mattmattmatt]

thanks. it is working now.