Match wild cards and then count
 

Afternoon

I have a data set (50K+) with various product codes such as 618B TPR, 618B
PGR, 13 VCR etc.

Firstly I want to complete a count exercise using the above codes to see how
often they match themselves within a description of the item. Where it is a
1:1 match I will then aling these data records with each.

Thanks

Match wild cards and then count
 

Pete,

Your description is a bit sketchy.....

Look at Pivot tables to do the count, or use formulas like
=COUNTIF(A:A,"618*").

To align them, use Data Sort.... perhaps using some columns of formulas to help identify which codes
you want to group.

HTH,
Bernie
MS Excel MVP


"LITTLE PETE" wrote in message
...
Afternoon

I have a data set (50K+) with various product codes such as 618B TPR, 618B
PGR, 13 VCR etc.

Firstly I want to complete a count exercise using the above codes to see how
often they match themselves within a description of the item. Where it is a
1:1 match I will then aling these data records with each.

Thanks