AnsweredAssumed Answered

Count of value matches in 2 list - Custom Function?

Question asked by user5571 on Jan 16, 2016
Latest reply on Jan 16, 2016 by wkeja

I have 2 lists and I want to count the number of value matches the 2 list shares. For example,

 

List 1=

Apple

Orange

Banana

Mango

Peach

Plum

 

List 2=

Cherry

Banana

Melon

Mango

 

The desire result would be 2.  Does anyone know if there is a custom function out there that might do this?

Outcomes