I am trying to figure out a formula that will exclude the columns that are "false". And list the not false data by each row.
Not sure if it is a lookup formula or what formula is needed.
Can you please help?
Thank you
Please see file attached which is close to what you want. I used the technique for numbering grouped data in Power Query.
Hope that helps.
Mynda
I like how you make it so simply. I don't understand how it was done, I will read the material.
Can you give me a brief explanation what you did?
Also, is it possible to have the data presented horizontal instead of vertical. Can you set it up to have six (6) on each row?
Thank you so much for all of your help, greatly appreciated.
Can you assist me with a formula instead? I am not grasping Power Query. There is a lot more data to be added to the spreadsheet.
For the result in cell P4 you can use this formula:
=TEXTJOIN(,TRUE,SUBSTITUTE(D5:M6,"FALSE",""))
You'll have to change the cell references for the other rows.
Mynda
Hi Mynda,
Thank you so very much. You are a lifesaver!!