My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Microsoft Excel Formula Needed.|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Microsoft Excel Formula Needed.|Power Query|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Microsoft Excel Formula Needed.
Avatar
mymalone
Member
Members
Level 0
Forum Posts: 104
Member Since:
August 25, 2017
sp_UserOfflineSmall Offline
1
September 30, 2021 - 2:18 am
sp_Permalink sp_Print

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 

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4515
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
September 30, 2021 - 8:56 am
sp_Permalink sp_Print

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

Avatar
mymalone
Member
Members
Level 0
Forum Posts: 104
Member Since:
August 25, 2017
sp_UserOfflineSmall Offline
3
September 30, 2021 - 10:30 am
sp_Permalink sp_Print

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.

Avatar
mymalone
Member
Members
Level 0
Forum Posts: 104
Member Since:
August 25, 2017
sp_UserOfflineSmall Offline
4
October 1, 2021 - 7:02 am
sp_Permalink sp_Print

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.

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4515
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
5
October 1, 2021 - 12:33 pm
sp_Permalink sp_Print sp_EditHistory

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

Avatar
mymalone
Member
Members
Level 0
Forum Posts: 104
Member Since:
August 25, 2017
sp_UserOfflineSmall Offline
6
October 1, 2021 - 12:44 pm
sp_Permalink sp_Print

Hi Mynda,

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

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Andrew Wilkie, Sue Hammond, Malcolm Sawyer
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6355
Posts: 27792

 

Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen