Match duplicate entries in diff columns

**nature718** · 07-08-2011, 09:06 AM

Hey guys.. I have 2 rows with dates. I want to see how many matches I have between these 2 rows. How can I go about doing this? I know it has something to do with conditional formatting.

Thanks.

**martindwilson** · 07-08-2011, 09:36 AM

assuming column a and b
say a2:a100 and b2:b200
select a2:a100
go to conditional format
chose formula is option and put
=countif($b$2:$b$200,a2)
chose a colour and apply
repeat with column b2:b200
=countif($a$2:$a$100,b2)

**nature718** · 07-08-2011, 09:49 AM

I'm sorry.. I dont think I was that clear. I've attached a sample file for your convenience. I just want to find out how many times columns A and C match (and maybe place the total amount in column B). .. does ur answer still apply?

**TMS** · 07-08-2011, 12:27 PM

Use CF with the condition:

=COUNTIF(C:C,A1)>0

Select all the cells in column A before applying CF.

Just use the formula: =COUNTIF(C:C,A1) and drag down in column B for the actual count.

Regards