omp001
04-05-2014, 07:57 PM
Hi all.
Please I need a formula to count the numbers that are simultaneously in two groups of numbers.
If a number from the first group is matched on the second and it's duplicated on the second it should be counted only once.
Please see attached sample.
Many thanks in advance.
Please I need a formula to count the numbers that are simultaneously in two groups of numbers.
If a number from the first group is matched on the second and it's duplicated on the second it should be counted only once.
Please see attached sample.
Many thanks in advance.