Hi,
I would like to know how which formula I should use to count some codes & to
ignore the duplicated codes, for example in column A:
Code
1234
4321
4321
1234
1234
3214

Now, I want Excel to count & the result is 3 which a
1234-4321-3214

Yes I can use PivotTable, but I would like to use a formula because I have
to deal with this every day.

I appreciate your support.

--
MFS22