Forum Discussion
Solved
Search for Highlighted Cells
Hello, I am an occasional Excel user working on a special project where I created an Excel spreadsheet whose data consists of a large number of comments. What I am trying to do is find any cell tha...
Let's say your data are in A2:Z50 on a sheet named Sheet 1.
On another sheet:
=LET(v, TOCOL('Sheet 1'!A2:Z50, 1), FILTER(v, ISNUMBER(SEARCH("white", v)), ""))
Let's say your data are in A2:Z50 on a sheet named Sheet 1.
On another sheet:
=LET(v, TOCOL('Sheet 1'!A2:Z50, 1), FILTER(v, ISNUMBER(SEARCH("white", v)), ""))