C
Cheng Joo
Column A Column B Column C
Column D
Manufacturer Scale Quantity
Model
Witty Wings 1:72 1 F-15
Witty Wings 1:72 1
F-16
Japanese Kit (Toy) 1:144 1
F-117
Tamiya Kit 1:72 2
AV-8B
Japanese Kit (Toy) 1:144 1
F-16
Xi Fei 1:48 1
Su-27
Tamiya Kit 1:72 1
RAH-66
Hogan 1:200 1
B747
Italeri Kit 1:48 1
EF2000
Maisto 1:144 1
F-16
Tamiya Kit 1:72 1
Skyray
Matchbox 1:144 1
F-16
Total No.: 13
Looking at the above case, using a formula or a combination of formulae in
Column F (in the example below), how can I create a statistics table showing
the number of times a manufacturer appears while still keeping correct count
of the total number of models?
The statistics table should look like this:
Column E Column F
Manufacturer Number
Witty Wings 2
Tamiya Kit 4
. .
. .
. .
. .
TOTAL 13
Sorry for the trouble and thanks in advance for helping me.
Column D
Manufacturer Scale Quantity
Model
Witty Wings 1:72 1 F-15
Witty Wings 1:72 1
F-16
Japanese Kit (Toy) 1:144 1
F-117
Tamiya Kit 1:72 2
AV-8B
Japanese Kit (Toy) 1:144 1
F-16
Xi Fei 1:48 1
Su-27
Tamiya Kit 1:72 1
RAH-66
Hogan 1:200 1
B747
Italeri Kit 1:48 1
EF2000
Maisto 1:144 1
F-16
Tamiya Kit 1:72 1
Skyray
Matchbox 1:144 1
F-16
Total No.: 13
Looking at the above case, using a formula or a combination of formulae in
Column F (in the example below), how can I create a statistics table showing
the number of times a manufacturer appears while still keeping correct count
of the total number of models?
The statistics table should look like this:
Column E Column F
Manufacturer Number
Witty Wings 2
Tamiya Kit 4
. .
. .
. .
. .
TOTAL 13
Sorry for the trouble and thanks in advance for helping me.