Forum

Microsoft Excel For...
 
Notifications
Clear all

Microsoft Excel Formula Needed.

6 Posts
2 Users
0 Reactions
130 Views
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

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 

 
Posted : 30/09/2021 12:18 pm
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 30/09/2021 6:56 pm
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

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.

 
Posted : 30/09/2021 8:30 pm
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

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.

 
Posted : 01/10/2021 5:02 pm
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 01/10/2021 10:33 pm
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

Hi Mynda,

Thank you so very much.  You are a lifesaver!!

 
Posted : 01/10/2021 10:44 pm
Share: