Count Unique Items

Hi All,

I have a simple question. I have a worksheet that has 2 columns and need to count the unique items. See Below. Column A i = Customer, Column B = Tier, Result is the count where I need formula

A B Result

ABC 1 1
ABC 1 0
ABC 2 1
DEF 3 1
DEF 3 0
DEF 1 1

Thanks

Hi,

Your formula =IF(OR(A2<>A1,B2<>B1),1,0) works if you don't have a repeat of Customer & tier later in the list. For example if you add an additional Customer at the bottom of the list:

DEF 3 , it will count as addition. It needs to not count since it was already counted 3 rows up.

Thanks,

The point was that the data appeared sorted, if it isn't then that's a different problem.

alansidmans' solution might be the way to go.

If not, can you post a typical sample workbook that better illustrates your problem?