I keep getting errors after the search function is added. Please see attached file. I am looking to get a clean list of active project numbers and descriptions starting in cell F5.
I have an INACTIVE column that, once filled, formats the text to the left as strikethrough.
The bottom of the list is at ROW 1001
Here is my desire:
Pull a list of project numbers and names that have NOTHING in the INACTIVE column (column D). In other words, I would like a clean list of only ACTIVE projects.