Advanced filter remove blank rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2469973%22%20slang%3D%22en-US%22%3EAdvanced%20filter%20remove%20blank%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2469973%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20with%20multiple%20columns%20to%20filter%20at.%20The%20columns%20are%20Y%2FN%20values%20but%20sometimes%20a%20row%20has%20been%20missed%20completely%20or%20partially%20and%20these%20Y%2FN%20cells%20are%20left%20blank.%20The%20goals%20is%20to%20create%203%20filtered%20tables%3B%20Approved%2C%20Denied%20and%20Review%20needed.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20trying%20a%20filter%20that's%20simply%20just%20%26lt%3B%26gt%3B%20but%20I%20realise%20this%20create%20some%20sort%20of%26nbsp%3B%20an%20unwanted%20wildcard%20as%20this%20allows%20both%20Y%20and%20N%20values%20when%20the%20goal%20is%20to%20remove%20the%20blank%20rows.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20remove%20them%20in%20the%20advanced%20filter%3F%20It%20was%20way%20easier%20to%20add%20them%20to%20the%20review%20needed%20table%20as%20I%20did%20a%20filter%20table%20with%20all%20the%20possible%20blank%20variants.%20So%20I%20have%20that%20table%20if%20it's%20to%20any%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2469973%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2470230%22%20slang%3D%22en-US%22%3ERe%3A%20Advanced%20filter%20remove%20blank%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2470230%22%20slang%3D%22en-US%22%3EBetter%20you%20upload%2Fattach%20the%20file%20with%20the%20table%20%2B%20mention%20which%20version%20of%20Excel%20on%20run%20%26amp%3B%20on%20which%20platform%20(Windows%2FMac)%3C%2FLINGO-BODY%3E
Occasional Contributor

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. 

2 Replies
Better you upload/attach the file with the table + mention which version of Excel on run & on which platform (Windows/Mac)

@Wiiilda 

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.

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)