Kevin Neufeld
Board Regular
- Joined
- Oct 6, 2014
- Messages
- 50
In the spreadsheet below I have information that represents truckloads of steel. The different colors represent one individual load that has multiple shipper cities and / or multiple receiver cities. The loads however are on different Lines. They are identified by a unique Load ID (column B). The Blue Lines represent a load that had 2 different pickup cities and 2 different receiver cities.
What I want to capture is the amount of times each load combination happened. For example below we have 4 different loads. Load ID 1023765 is Shipper 1 Madison, Shipper 2 Red Bud, Receiver 1 Paris, Receiver 2 Flora.
Can anyone give me some help?
Thanks.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[/TR]
[TR]
[TD][TABLE="width: 67"]
<tbody>[TR]
[TD="align: center"]Transport Order ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="align: center"]Load ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="align: center"]Shipper [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 76"]
<tbody>[TR]
[TD="align: center"]Shipper City[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="align: center"]Receiver City[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 92"]
<tbody>[TR]
[TD="align: center"]Gross Weight [lb] (Load)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 92"]
<tbody>[TR]
[TD="align: center"]Gross Weight [lb] (TO)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"]10331622[/TD]
[TD="align: center"]1023765
[/TD]
[TD="align: center"]Custom Steel
[/TD]
[TD="align: center"]Madison[/TD]
[TD="align: center"]Paris[/TD]
[TD="align: center"]44470[/TD]
[TD="align: center"]24280[/TD]
[/TR]
[TR]
[TD="align: center"]10331624[/TD]
[TD="align: center"]1023765[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Red Bud[/TD]
[TD="align: center"]Flora[/TD]
[TD="align: center"]44470[/TD]
[TD="align: center"]20190[/TD]
[/TR]
[TR]
[TD="align: center"]10333000[/TD]
[TD="align: center"]1025493[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Madison[/TD]
[TD="align: center"]Paris[/TD]
[TD="align: center"]46734[/TD]
[TD="align: center"]15212[/TD]
[/TR]
[TR]
[TD="align: center"]10333002[/TD]
[TD="align: center"]1025493[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Red Bud[/TD]
[TD="align: center"]Paris[/TD]
[TD="align: center"]46734[/TD]
[TD="align: center"]31522[/TD]
[/TR]
[TR]
[TD="align: center"]10333009[/TD]
[TD="align: center"]1025498[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Madison[/TD]
[TD="align: center"]Flora[/TD]
[TD="align: center"]45980[/TD]
[TD="align: center"]38710[/TD]
[/TR]
[TR]
[TD="align: center"]1033010[/TD]
[TD="align: center"]1025498[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Red Bud[/TD]
[TD="align: center"]Paris[/TD]
[TD="align: center"]45980[/TD]
[TD="align: center"]7270[/TD]
[/TR]
[TR]
[TD="align: center"]1033623[/TD]
[TD="align: center"]1026131[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Red Bud[/TD]
[TD="align: center"]Paris[/TD]
[TD="align: center"]43211[/TD]
[TD="align: center"]39632[/TD]
[/TR]
[TR]
[TD="align: center"]1033624[/TD]
[TD="align: center"]1026131[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Red Bud[/TD]
[TD="align: center"]Flora[/TD]
[TD="align: center"]43211[/TD]
[TD="align: center"]3579[/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 249px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Custom Steel[/TD]
[/TR]
</tbody>[/TABLE]
What I want to capture is the amount of times each load combination happened. For example below we have 4 different loads. Load ID 1023765 is Shipper 1 Madison, Shipper 2 Red Bud, Receiver 1 Paris, Receiver 2 Flora.
Can anyone give me some help?
Thanks.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[/TR]
[TR]
[TD][TABLE="width: 67"]
<tbody>[TR]
[TD="align: center"]Transport Order ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="align: center"]Load ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="align: center"]Shipper [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 76"]
<tbody>[TR]
[TD="align: center"]Shipper City[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="align: center"]Receiver City[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 92"]
<tbody>[TR]
[TD="align: center"]Gross Weight [lb] (Load)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 92"]
<tbody>[TR]
[TD="align: center"]Gross Weight [lb] (TO)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"]10331622[/TD]
[TD="align: center"]1023765
[/TD]
[TD="align: center"]Custom Steel
[/TD]
[TD="align: center"]Madison[/TD]
[TD="align: center"]Paris[/TD]
[TD="align: center"]44470[/TD]
[TD="align: center"]24280[/TD]
[/TR]
[TR]
[TD="align: center"]10331624[/TD]
[TD="align: center"]1023765[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Red Bud[/TD]
[TD="align: center"]Flora[/TD]
[TD="align: center"]44470[/TD]
[TD="align: center"]20190[/TD]
[/TR]
[TR]
[TD="align: center"]10333000[/TD]
[TD="align: center"]1025493[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Madison[/TD]
[TD="align: center"]Paris[/TD]
[TD="align: center"]46734[/TD]
[TD="align: center"]15212[/TD]
[/TR]
[TR]
[TD="align: center"]10333002[/TD]
[TD="align: center"]1025493[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Red Bud[/TD]
[TD="align: center"]Paris[/TD]
[TD="align: center"]46734[/TD]
[TD="align: center"]31522[/TD]
[/TR]
[TR]
[TD="align: center"]10333009[/TD]
[TD="align: center"]1025498[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Madison[/TD]
[TD="align: center"]Flora[/TD]
[TD="align: center"]45980[/TD]
[TD="align: center"]38710[/TD]
[/TR]
[TR]
[TD="align: center"]1033010[/TD]
[TD="align: center"]1025498[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Red Bud[/TD]
[TD="align: center"]Paris[/TD]
[TD="align: center"]45980[/TD]
[TD="align: center"]7270[/TD]
[/TR]
[TR]
[TD="align: center"]1033623[/TD]
[TD="align: center"]1026131[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Red Bud[/TD]
[TD="align: center"]Paris[/TD]
[TD="align: center"]43211[/TD]
[TD="align: center"]39632[/TD]
[/TR]
[TR]
[TD="align: center"]1033624[/TD]
[TD="align: center"]1026131[/TD]
[TD="align: center"]Custom Steel[/TD]
[TD="align: center"]Red Bud[/TD]
[TD="align: center"]Flora[/TD]
[TD="align: center"]43211[/TD]
[TD="align: center"]3579[/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 249px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Custom Steel[/TD]
[/TR]
</tbody>[/TABLE]