How can I count the number of similar linked record between two columns?

Hi, I need help with the following.

On sheet 1, I have a list of tags as primary fields. Let’s say “outdoor”, “indoor”, “both”.

On sheet 2, my primary field is people. People have preferences of places to go out to, so I tag people using “link to another record” and tag them with one or two of the tags from sheet 1.

On sheet 3, my primary field is a list of places. Similarly to with people, I tag places using “link to another record” and tag them with one or two of the tags from sheet 1.

How can I compute the number of tags that a person and a place share together?

Thanks a lot in advance.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.