List Cells with Certain Value in One Cell

[Lana74]

Hello,

Here is what I'm trying to do:


I have a list of companies. Each company has lets say 5 metrics: M1, M2, M3, M4 and M5. Each metric has a value of 0 or 1. I want to list all metrics with value of 1 in one cell. Something like this:


Company M1 M2 M3 M4 M5 Flagged
ABC 0 0 0 1 0 M4
NBC 1 1 0 0 0 M1,M2
BBC 0 0 1 1 0 M3,M4

Please let me know if this makes sense. Any help is grealy appreaciated.

[Special-K]

I saw someone post a question like this on this forum within the past week.
Can't recall the solution, do a search on here for recent questions regarding concatenate/concatenation

[Arkadi]

How about this:

Please Login or Register  to view this content.

[cyiangou]

Assume your test data is in cells A1:G4, enter the following formula in G2 and copy down.

Please Login or Register  to view this content.