Hi

Grateful if you may provide me a formula to count a series of data if the
data does not match with any number on the whole list. Example:

COLUMN A COLUMN B COLUMN C RESULTING COUNT
aaa 100 ccc 1
aab 200 bbb 2
aaa 300 aaa 3
aaa 100 ccc 1

I want to count data if range a1:c1 (etc) matches exactly with any of the
data in the range (i.e a1:c4). If a match is found then they should have the
exact count as the previous value of the first match found otherwise it will
count consecutively.