Match wild cards and then count

[LITTLE PETE]

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

 

[Bernie Deitrick]

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