Search engine for excel

[greg2091]

I am looking to refine my search page on excel, for reference I have a sheet with nearly 1000 rows and each row has nearly 100 cells of information, most of this information is true/false but some is written data. I have found a way to refine the search for relevant rows using the "Filter", "Isnumber", and "Search" functions, however I am looking for a way to refine the data further based on the True/False segments. The issue I am running into is that this will only return true OR false sections, but I am looking for a way to return the rows where a specific cell is labeled "True" when I am looking for that criteria, but when I am not looking for that criteria specifically it returns all rows where those cells are labelled both True AND False. Any help would be appreciated!!

 

[KRice]

You’re welcome…happy to help.