Forum Discussion
Find cells hidden by filter
I never realized but FIND (and the equivalent function in VBA) only looks at the selected cells of a Filter. I can see no option to change that behaviour. Does anyone know how to search all cells (...
Not top clear what you mean with Filter: FILTER function, Filter functionnality on the Home tab, Filter functionnality on a Table??? Assuming Table...
Unfiltered:
Filtered:
in G2:
=XMATCH("*" & E2 & "*", Table1[Name], 2)
I learned something new in the process: A row hidden by a Filter (which cannot be found by Find) is distinct from a row hidden by Hide (which will be found by Find). That is, Filter does not seem to use Hide as a means by which to arrive at its presentation.