csehz
asked on
Excel 2010 - Count common elements
Dear Experts,
Can you please have a look at the attached file, it contains small data on Sheet1 and Sheet2, both in A column.
Could you advise which formula could give back a number that how many common elements are on the two sheets in column A? In the example this would be 3, because only the 101,102 and 107 are on both sheets
thanks,
CommonInColumn.xlsx
Can you please have a look at the attached file, it contains small data on Sheet1 and Sheet2, both in A column.
Could you advise which formula could give back a number that how many common elements are on the two sheets in column A? In the example this would be 3, because only the 101,102 and 107 are on both sheets
thanks,
CommonInColumn.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Possibly. But that would be a different question, since this one has been answered.
ASKER
Thanks :-)
Can there be duplicates? For example if A6 became 102 there would still arguably be 3 common elements......but teylyn's formulas would return 4?
regards, barry
regards, barry
ASKER
Barry well for me fortunately on the live files the columns sure do not have duplicates. So I even did not think to such scenario, however yes can be a good next question too :-)
ASKER
thanks,