Forum Discussion
How to delete FALSE response in Excel IFS formula
I want to display entries from Column B in all instances where a condition is met in Column G. For instance, for all rows where Column G is "Wed" I want to list each of the corresponding Column B ent...
NoviceGuy Try the FILTER function wrapped in TEXTJOIN. For example:
=TEXTJOIN(",", TRUE, FILTER(B3:B8, G3:G8="Wed", "None"))
This appears to be what you are trying to accomplish by concatenating multiple IF functions with ",".