search for part of string

[benj]

hi, the problem i'm facing here is that i have a column of titles and another column which holds the Shop ID, say Column A contains 1000 rows of titles and Column B contains the ShopID which has that title.
*each shop can have more than 1 title being sold within the shop

I wan to do a search thru all the rows and return a count where the word "Short" exists in the title and they are all from the same shop. Eg, ShopID = 001 has 5 titles which has the word "Short" and ShopID = 003 has 10 titles which has the word "Short". As such how can i write the VBA code to do the search and keep track of the count?

[AlfD]

Hi!

I think I would look first at AutoFilter and watch the Autosum counter in the status bar for my results.

Alf