View Full Version : sort by 4 criteria

12-09-2008, 07:19 AM
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 :)

: pray2:

Bob Phillips
12-09-2008, 07:33 AM
Sort by the two least important criteria, then sort again by the two most importanyt criteria.

12-09-2008, 07:36 AM
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
12-09-2008, 07:37 AM
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.

12-09-2008, 07:50 AM
thanks. it is working now.