Forum Discussion
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...
No, FILTER just returns the values of the cells satisfying the condition, not their formatting, nor their formulas.
Is there a function that will return the text and the formatting?HansVogelaar
No, there isn't.