Excel - Count the number of match
Hi,
I have an excel file where i would like to count the number of time a "From A" and "From B" from list 1 exist in List 2 "From A" and "From B".
In below picture, in list 1 as an example, 3 times, the value "10" From B have an existing match on the "From A" value. The formula would count it.
So the formula i'm truing to build in column H2 is to count the number of match:
If From B values from both lists = cell G2 value
And List 1 "From A" have match in List 2 "From A"
I hope i'm clear on what i'm looking for.
How can i do that?
Please let me know if i'm not.
Thank you for your help
I have an excel file where i would like to count the number of time a "From A" and "From B" from list 1 exist in List 2 "From A" and "From B".
In below picture, in list 1 as an example, 3 times, the value "10" From B have an existing match on the "From A" value. The formula would count it.
So the formula i'm truing to build in column H2 is to count the number of match:
If From B values from both lists = cell G2 value
And List 1 "From A" have match in List 2 "From A"
I hope i'm clear on what i'm looking for.
How can i do that?
Please let me know if i'm not.
Thank you for your help
Saqib Husain
How about uploading a working excel file?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, sorry for the long delay.
Here is a sample of the file with byundt formula in it.
I'm doing some test cause it looks like when the 2 lists are in a different sheet and with a larger volume, it causes problem. If both lists don't have the same amount of rows, it does not count properly.
Match-count.xlsx
Here is a sample of the file with byundt formula in it.
I'm doing some test cause it looks like when the 2 lists are in a different sheet and with a larger volume, it causes problem. If both lists don't have the same amount of rows, it does not count properly.
Match-count.xlsx
ASKER
Thanks for your help.