Sorting

ncferro · Mar 14th, 2002, 01:54 PM

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 ]

Slick · Mar 14th, 2002, 02:17 PM

Have you tried doing sub sorts on your columns? You may have all ready done this but thought I would mention it.

Rick

Von Pookie · Mar 14th, 2002, 02:23 PM

Maybe try using the autofilter? Choose one item from column b, and the rest should automatically filter to the same thing.

Hope that helps (and makes sense for that matter!

)

_________________
"What am I, a magnet for these idiots?"
--Pearl Forrester, MST3K

[ This Message was edited by: Von Pookie on 2002-03-14 13:24 ]

Mark W. · Mar 14th, 2002, 03:01 PM

You'd have an easier time if your data was reorganized. Why have you chosen this organization? I understand the columns B:P contain load descriptions, but are these at different times, dates, or possible configurations? Why 15 columns? Are some of these cells in these columns empty? Can you provide some sample data?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 01:54 PM	#1
ncferro New Member Join Date: Mar 2002 Posts: 2	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 ]

Mar 14th, 2002, 02:17 PM	#2
Slick New Member Join Date: Mar 2002 Posts: 5	Have you tried doing sub sorts on your columns? You may have all ready done this but thought I would mention it. Rick

Mar 14th, 2002, 02:23 PM	#3
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Maybe try using the autofilter? Choose one item from column b, and the rest should automatically filter to the same thing. Hope that helps (and makes sense for that matter! ) _________________ "What am I, a magnet for these idiots?" --Pearl Forrester, MST3K [ This Message was edited by: Von Pookie on 2002-03-14 13:24 ]

Mar 14th, 2002, 03:01 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	You'd have an easier time if your data was reorganized. Why have you chosen this organization? I understand the columns B:P contain load descriptions, but are these at different times, dates, or possible configurations? Why 15 columns? Are some of these cells in these columns empty? Can you provide some sample data?