Dumb recommendation system by matching lists

[ed727]

On the question of whether it’s possible to sort by # of intersects, some threads here grapple with it. I haven’t spent enough time to get to the bottom of it, but it’s on my to do list.

Best Intersect between 2 lists

Hello! I have several “accounts”. Each account has a “list of categories”. I want to select an account and get the other account for which the intersect of their “list of categories” returns the maximum count. However, I’m stuck. I am able to get a filter in place with the intersect count >0 but am not able to get the account whose list of categories has more in common with the current account. Can anyone help me out?