I have a string. (say persons name)
I want to see if the name appears in another column (the column contains many other names, may even contains the name I am looking for more than once).
Once that name has been found, I want to see if (on that same row) another value exists (the activity they participated in).
In summary, I have a list of people and all of the activities they have participated in. A person may have done more than one activity. (There are a total of 4 unique activities, say football, baseball, basketball soccer).
On one line I’d like to see which activites they have completed.
JACK > FOOTBALL >SOCCER > BASEBALL
BOB > BASEBALL
JEFF > BASEBALL > BASKETBALL