Dr. Demento
Well-known Member
- Joined
- Nov 2, 2010
- Messages
- 618
- Office Version
- 2019
- 2016
- Platform
- Windows
I attempted to ask for assistance in a prior thread but evidently wasn't specific enough.
Original thread: Convert to 2019
I have 365 at the office but 2019 at home. Can someone help me "translate" the FILTER portion of this formula so that it will work in 2019?
It's used to merge multi-select answers that are identified by starting with "# ".
Excel Formula:
Thanks, y'all.
Original thread: Convert to 2019
I have 365 at the office but 2019 at home. Can someone help me "translate" the FILTER portion of this formula so that it will work in 2019?
It's used to merge multi-select answers that are identified by starting with "# ".
Excel Formula:
Excel Formula:
TEXTJOIN("\",TRUE,FILTER([[#Headers],[A]:[G]],ISNUMBER(SEARCH("# *",[@[A]:[G]]))*("# *"<>""),"No results"))
Thanks, y'all.