0

What is a formula to pull the States of overlap in a list separated by commas like in this example?

KiXcg.png

Improve this question
1
  • 3
    Kyle, please note that this site is not a script writing service. Please show the effort you have made to try to solve this problems yourself, the things you've tried, etc, in your questions.
    – music2myear
    Commented Jun 11 at 20:55

1 Answer 1

Reset to default
1

You can use either:
=TEXTJOIN(", ",,FILTER(A6:D6,COUNTIF(A3:H3,A6:D6)))
or for entire rows:
=TEXTJOIN(", ",,FILTER(6:6,COUNTIF(3:3,6:6)))

Overlap

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .