Show Names in the same Cell

[l_grassic]

Hello, i have a problem trying to figure out how to make a formula that shows me the correspondent names in columns.
Example:

A B C D 1 // First Second Third 2 John X X X 3 Carlos X // // 4 Anna // X X

I need to show in a cell all names for: First (John and Carlos), another cell for Second (John and Anna) and last cell for Third (John and Anna)

PS: Sorry about my english, its not my native language.

[6StringJazzer]

I don't understand the description of what you need. I think your English is fine, but the description doesn't explain what result you need. I think it is probably because the way you are showing the data doesn't look much like an Excel sheet.

Please see the yellow banner at the top of the page and attach a file. Your file should show an example of your data, and also manually show what result you want from that data.

[l_grassic]

Sorry, here's the attachment for better view.

[Fluff13]

How about in F2 dragged right

Please Login or Register  to view this content.

[l_grassic]

It worked!!!!

THANKS!!!

[Fluff13]

You're welcome & thanks for the feedback.