Excel Question

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.

Example:

Jack FOOTBALL
Bob BASEBALL
Jeff BASEBALL
Jack SOCCER
Jack BASEBALL
Jeff BASKETBALL

JACK > FOOTBALL >SOCCER > BASEBALL
BOB > BASEBALL
JEFF > BASEBALL > BASKETBALL

By: Amish

Leave a Reply

Your email address will not be published. Required fields are marked *