Thank you in advance for all replies.

I have a column in a worksheet which contains a series of 2 character
codes separated by commas:

ac, bg, hj, r4, qt, mr
ac,mr,t7
mr,e3,bg

search will return a value for starting position in each cell, and
countif will return a count, but mixing the two together escapes me.

Sure there's a way. (SQL is sooooo much easier.)


Jeff N. Cantwell
Downtown Little Rock

NRA, ARPA, Libertarian
'86, '91 300zx 2+2