foxtrapperscott
New Member
- Joined
- Oct 4, 2008
- Messages
- 31
Thanks for taking time to help. I have a spreadsheet that has a list of dealer numbers that have different model numbers per dealer location. I need to be able to count the number of similar models per dealer location. Please see below
Thanks in advance or taking time to help. I greatly appreciate it.
-Scott
<colgroup><col width="103" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;">
<col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;">
<col width="109" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;">
<col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;">
<col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;">
<col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;">
<col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;">
<col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;">
<col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;">
<col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;">
<col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3291;">
<col width="109" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;">
<col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;">
<col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;">
<tbody>
</tbody>
Thanks in advance or taking time to help. I greatly appreciate it.
-Scott
Dealer Number | Dealer Name | District Manager | Region | Demand Class | Order Type | Factory Order | Model Number | Serial Number | Order Date | Request Date | Schedule Arrival | EBC | Sequence |
09757 | WECO | KC | Region 500 | A | STOCK | 2353625 | E50 T4 | BR549 | 8/7/2014 | 2/28/2014 | 1/12/2015 | 12/17/2015 | 4 |
09757 | WECO | KC | Region 501 | A | STOCK | 2353626 | T550 T4 | BR550 | 10/22/2014 | 1/1/2015 | 1/15/2015 | 1/7/2015 | 170 |
09572 | BONV | KC | Region 501 | A | STOCK | 2393926 | T550 T4 | BR551 | 10/23/2014 | 1/1/2015 | 1/15/2015 | 1/7/2015 | 171 |
09572 | BONV | KC | Region 501 | A | STOCK | 2393926 | T550 T4 | BR552 | 10/23/2014 | 1/1/2015 | 1/15/2015 | 1/7/2015 | 172 |
09572 | BONV | KC | Region 501 | A | STOCK | 2393926 | T550 T4 | BR553 | 10/23/2014 | 1/1/2015 | 1/15/2015 | 1/7/2015 | 173 |
09758 | BOR | JM | Region 502 | A | STOCK | 2305005 | S70 | BR554 | 5/14/2014 | 10/1/2014 | 1/15/2015 | 1/7/2015 | 226 |
08948 | BOF | KC | Region 503 | A | STOCK | 2376704 | 5600T T4 | BR555 | 9/22/2014 | 11/1/2014 | 1/17/2015 | 1/8/2015 | 334 |
09516 | BOT | JM | Region 504 | A | STOCK | 2284267 | 5600T T4 | BR556 | 4/13/2014 | 4/13/2014 | 1/22/2015 | 1/9/2015 | 857 |
Results I am looking for number of models by dealer number | |||||||||||||
09572 | 09516 | 09758 | 08948 | 09757 | |||||||||
Style | BONV | BOT | BOR | BOF | WECO | TOTAL | |||||||
E50 T4 | 1 | 1 | |||||||||||
T550 T4 | 3 | 1 | 4 | ||||||||||
S70 | 0 | ||||||||||||
5600T T4 | 1 | 1 | 2 |