Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Count(if(SearchNo=SearchNo1,SearchNo))
So easy Its scary how it took me so long to figure out _+im a little embarrassed
This is easier to see I think
Thanks
Count(if(SearchNo=SearchNo1,SearchNo))
So easy Its scary how it took me so long to figure out _+im a little embarrassed