COUNT
 

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.

COUNT
 

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



"Rachel" wrote:

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.