How to find Items in Sheet that are not in dropdown list?

Options
Cheree Peterson
Cheree Peterson ✭✭✭✭

We have a column that has a dropdown list. I have it selected where what is entered has to be in the dropdown list but have admins can override the entry. This is ok because I don't want them to be slowed down when adding a new entry. However, I would like to go back after the fact to find entries that are not in the drop down list to verify if they are a new entry or a duplicate that was overlooked and add them to the drop down list. I get a message telling me how many entries are NOT in the drop down list but I am having trouble finding a way to locate them either through a filter or a report. Any suggestions?

Best Answer

Answers