Comparing 2 tables - not working --

[#1]

Hi Experts

Please help --

I have 2 tables which I wish to compare for matches. I have created Unique Identifiers [SearchNos] on each and now wish to create charts when the unique identifier is common for both tables.

Can you please have a look at screen shot and explain why its not working how Id like.

I wish for it to only count the first row where SearchNo = SearchNo1, yet it is counting both !

Can anyone please advise ?

Thanks

A

[#2]

This is easier to see I think

Thanks

[#3 · Accepted solution]

Count(if(SearchNo=SearchNo1,SearchNo))

So easy Its scary how it took me so long to figure out _+im a little embarrassed