Advanced Filter, In-Place, Unique records only is not hiding duplicate rows

%3CLINGO-SUB%20id%3D%22lingo-sub-1260479%22%20slang%3D%22en-US%22%3EAdvanced%20Filter%2C%20In-Place%2C%20Unique%20records%20only%20is%20not%20hiding%20duplicate%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1260479%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20where%20duplicate%20records%20are%20valid.%3C%2FP%3E%3CP%3EI%20do%20not%20want%20to%20remove%20them%2C%20just%20temporarily%20hide%20them%20to%20display%20and%20print%20only%20the%20unique%20records.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdvanced%20Filter%2C%20In-place%2C%20Unique%20records%20only%20shows%20246%20of%20252%20in%20lower%20left%20of%20sheet.%3C%2FP%3E%3CP%3EThe%20filter%20is%20being%20applied%20but%20the%20display%20and%20the%20print%20preview%20are%20still%20showing%20all%20252%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1260479%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1260489%22%20slang%3D%22en-US%22%3ERe%3A%20Advanced%20Filter%2C%20In-Place%2C%20Unique%20records%20only%20is%20not%20hiding%20duplicate%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1260489%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20will%20suggest%20you%20use%20normal%20filter%20to%20filter%20the%20data%20to%20exactly%20what%20you%20want%20to%20print.%20After%20that%2C%20copy%20the%20unique%20data%20to%20another%20sheet%20and%20print...%20Just%20my%20suggestion!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1260510%22%20slang%3D%22en-US%22%3ERe%3A%20Advanced%20Filter%2C%20In-Place%2C%20Unique%20records%20only%20is%20not%20hiding%20duplicate%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1260510%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%20Thanks%20for%20the%20reply!%20Unique%20records%20only%20IS%20the%20criteria.%3C%2FP%3E%3CP%3EThe%20feature%20is%20in%20Excel%202019%2C%20so%20I'm%20sure%20it's%20meant%20to%20do%20what%20I%20want%2C%20plus%20it's%20showing%20a%20filter%20results%20message%2C%20%22246%20of%20252%20records%22%20that%20declares%20it's%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20doing%20exactly%20what%20the%20Excel%20Help%20file%20says%20to%20do%2C%20so%20I'm%20at%20a%20loss%20as%20to%20why%20it's%20not%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1260775%22%20slang%3D%22en-US%22%3ERe%3A%20Advanced%20Filter%2C%20In-Place%2C%20Unique%20records%20only%20is%20not%20hiding%20duplicate%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1260775%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BFYI%2C%20I%20discovered%20that%20it%20was%20working%2C%20but%20it%20was%20leaving%20the%20room%20numbers%20alone%2C%20which%20fooled%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a sheet where duplicate records are valid.

I do not want to remove them, just temporarily hide them to display and print only the unique records. 

 

Advanced Filter, In-place, Unique records only shows 246 of 252 in lower left of sheet.

The filter is being applied but the display and the print preview are still showing all 252 rows.

 

What am I doing wrong?

Thank you!

3 Replies
Highlighted
Hello,



Hello,

I will suggest you use normal filter to filter the data to exactly what you want to print. After that, copy the unique data to another sheet and print... Just my suggestion!
Highlighted

@Abiola1  Thanks for the reply! Unique records only IS the criteria.

The feature is in Excel 2019, so I'm sure it's meant to do what I want, plus it's showing a filter results message, "246 of 252 records" that declares it's working.

 

I'm doing exactly what the Excel Help file says to do, so I'm at a loss as to why it's not working.

 

 

Highlighted

@Abiola1 FYI, I discovered that it was working, but it was leaving the room numbers alone, which fooled me.