Check for at least one identical value in different column ranges based on ID

This works for your example so perhaps you can generalise it. The formula in D2 is


and is an array formula so must be confirmed with CTRL, SHIFT and ENTER.

enter image description here

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top