count codes in a column w. several codes in a same cell

Originally Posted by chum

Hi Carim,

yes but the problem is that there are some codes with 3 and some others with 4 characters, so even when I manually delimit the cells, I can not catch all codes correctly.
Do you have another suggestion ?

thanks !
Chum

Hi chum,

In Data, Text to Columns, try Delimited, Comma & SemiColon, then do a cut/paste of column B to the end of column A, repeat for columns C D and E, then Filter, Advanced Filter, Unique, Copy to location.

This will give a unique list, the last row is the count.

hth
---