COUNT

[Rachel]

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.

 

[Mike H]

Rachel,

I'd concatenate each row into a single column (say D) like this

=A1&B1&C1

Then this in E1 and drag down

=COUNTIF($D$1:$D$4,D1)

Mike