I have 100 trucks ( column A ) numbered 1 - 100 in rows 3 thru 102. Columns B-C-D-E-F-G-H-I-J-K-L-M-N-O-P represent what each truck is carrying. Some trucks have the same items from columns B thru P and some do not. I want to sort the columns B thru P to find which trucks are hauling the same loads. My hangup seems to be that the trucks have a truck # which I must maintain. I currently highlight the entire range ( including truck # in column A and sort by one column at a time. Is there a faster way ? Thanks...........
_________________
This message was edited by ncferro on 2002-03-14 12:56
_________________
This message was edited by ncferro on 2002-03-14 12:56