This content has been marked as final. Show 2 replies
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 ?