Forum Discussion
HotRodC
Jan 10, 2023Copper Contributor
We are using Excle as a DB tool with the search function of =Filter
The full command is: =FILTER(DataSet[#All],ISNUMBER(SEARCH(D6,DataSet[[#All],[Answer]])),"No Data") This command allows me to search on a word or partial word and display all the mentions of the wo...
HotRodC
Jan 11, 2023Copper Contributor
Is there a function that will return the text and the formatting?HansVogelaar
HansVogelaar
Jan 11, 2023MVP
No, there isn't.