Lookup dealer number and count same models

[foxtrapperscott]

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

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

<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>

 

[njimack]

This takes about 2 minutes using a pivot table...

Rows = Model No
Columns = Dealer No & Dealer Name
Values = any field (count, not sum)



Sheet3

*	A	B	C	D	E	F	G
1	*	*	*	*	*	*	*
2	*	*	*	*	*	*	*
3	Count of District Manager	Column Labels	*	*	*	*	*
4	*	8948	9516	9572	9757	9758	Grand Total
5	Row Labels	BOF	BOT	BONV	WECO	BOR	*
6	5600T T4	1	1	*	*	*	2
7	E50 T4	*	*	*	1	*	1
8	S70	*	*	*	*	1	1
9	T550 T4	*	*	3	1	*	4

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:168px;"><col style="width:114px;"><col style="width:48px;"><col style="width:48px;"><col style="width:48px;"><col style="width:48px;"><col style="width:79px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[foxtrapperscott]

Thank you so very much! I will try using this today.

 

[foxtrapperscott]

Thank you so very much!