Edit - Super User

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Rev

Thank you for the fast reply! The first and last formula didn’t work for me, however the CONCAT formula is showing some promise. It seems on multiple values (crimson-tide, bulldogs) that it’s not providing a Team Name. However a single value (warriors) is showing the name as expected. I’ve also noticed that for teams that share a word, for example, gonzaga-bulldogs and georgia-bulldogs, it will show both Football and Basketball because both teams share the “bulldogs” text. Even though the teams are unique. Any idea on how all of that may be alleviated?
– chunky-coal
Commented Mar 1 at 3:03
@chunky-coal can you show me few more examples with the expected output, it will definitely help me understand also I can see clearly for multiple values like crimson-tide, bulldogs it is returning correct output. Yes it will give you one output only because i have unique function here. For the other two bulldogs i am not able to understand if you share an excel or a screenshot it will help me more to understand to help you out
– Mayukh Bhattacharya
Commented Mar 1 at 10:59
Of course. I just made some edits and hopefully that will make it easier to understand. Thank you!
– chunky-coal
Commented Mar 1 at 15:13
@chunky-coal hello can you try this =IFERROR(CONCAT(UNIQUE(REPT(Sheet2!$A$1:$C$1,N(IFNA(TEXTSPLIT(C2,,", ")=Sheet2!$A$2:$C$5,0))))),"No Sport Hockey")
– Mayukh Bhattacharya
Commented Mar 1 at 15:38
1

Thank you so much!! This worked as expected. Sorry for the delay. I have marked this answer as resolved and you are a hero.
– chunky-coal
Commented Mar 7 at 4:29

| Show 8 more comments

Correct minor typos or mistakes
Clarify meaning without changing it
Add related resources or links
Always respect the author’s intent
Don’t use edits to reply to the author

create code fences with backticks ` or tildes ~
```
like so
```
add language identifier to highlight code
```python
def function(foo):
print(foo)
```
put returns between paragraphs
for linebreak add 2 spaces at end
_italic_ or **bold**
indent code by 4 spaces
backtick escapes `like _so_`
quote by placing > at start of line
to make links (use https whenever possible)
<https://example.com>
[example](https://example.com)
<a href="https://example.com">example</a>

formatting help »
answering help »