COUNT

R

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.
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top