Jun 22 2021 08:42 AM - edited Jun 22 2021 08:44 AM
I have a table with multiple columns to filter at. The columns are Y/N values but sometimes a row has been missed completely or partially and these Y/N cells are left blank. The goals is to create 3 filtered tables; Approved, Denied and Review needed.
I have been trying a filter that's simply just <> but I realise this create some sort of an unwanted wildcard as this allows both Y and N values when the goal is to remove the blank rows.
Is it possible to remove them in the advanced filter? It was way easier to add them to the review needed table as I did a filter table with all the possible blank variants. So I have that table if it's to any help.
Jun 22 2021 09:11 AM
Jun 22 2021 09:49 AM
Please read the information in the link. Please click on the link / heading so that you can come up with a proposed solution much faster.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)