One Cell listing all names checked off in another tab

[SeanD]

I have an excel that I am working on that has 2 Tabs. Tab 1 is a list of groups that can be selected by placing an x under there name from a list validation. Tab 2 is taking any names that have an x under them and placing them in a list for one cell and separating them by a comma while not including the names without the x.

Another problem is that I cannot use VBA or Macros for the excel. I was attempting to write this as something like this:

=IF(ISBLANK('Data & Logic Tab'!B12),"",'Data & Logic Tab'!B12) & IF(ISBLANK('Data & Logic Tab'!B13),"",", " & 'Data & Logic Tab'!B13) & IF(ISBLANK('Data & Logic Tab'!B14),"","," & 'Data & Logic Tab'!B14) & IF(ISBLANK('Data & Logic Tab'!B15),"","," & 'Data & Logic Tab'!B15)

I hope I am making sense. Any help would be appreciated.

So something like this.
Mike Jon Bill Amy
x x x


Mike, Jon, Amy

[ChemistB]

Moving only the ones with x's over is easy. Moving them over into a single cell is more difficult (without VBA). How many possible x's are we talking about here (if all names were checked?) Can you upload an example workbook (Go Advanced>Manage Attachments)?

[SeanD]

Example.xlsx

I attached a quick example. I was going to upload the original file but I think it might be too much to explain the excel first.

The most amount of names would be 9-10.

Thank you for your time.