K
Kristina
I need some help with a formula in excel. Iwould like to be able to count
the number of times each Item code appears for each store. Here is the data
table:
A B
Store Item code
cyam01 10
cyam01 10
cyam01 20
cyam02 10
cyam02 20
edar01 10
edar02 10
tita01 20
Also, e.g. cyam is 1 store (made up of cyam01 & cyam02) etc.
I require the results in this table format:
cyam edar tita
10 3 ? ?
20 2 ? ?
"?" is the number of times each item code (10 and 20) occurred for each
store.
For example the result for the store CYAM: Item code 10 appeared 3 times &
item code 20 appeared twice.
There are also times that there isn't a certain item for a store, so in this
case I don't want any error messages just a zero (0).
Thank you in advance for your help.
the number of times each Item code appears for each store. Here is the data
table:
A B
Store Item code
cyam01 10
cyam01 10
cyam01 20
cyam02 10
cyam02 20
edar01 10
edar02 10
tita01 20
Also, e.g. cyam is 1 store (made up of cyam01 & cyam02) etc.
I require the results in this table format:
cyam edar tita
10 3 ? ?
20 2 ? ?
"?" is the number of times each item code (10 and 20) occurred for each
store.
For example the result for the store CYAM: Item code 10 appeared 3 times &
item code 20 appeared twice.
There are also times that there isn't a certain item for a store, so in this
case I don't want any error messages just a zero (0).
Thank you in advance for your help.