Excel AutoFilter

%3CLINGO-SUB%20id%3D%22lingo-sub-2270780%22%20slang%3D%22en-US%22%3EExcel%20AutoFilter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2270780%22%20slang%3D%22en-US%22%3EI%20have%20more%20than%2010000%20records%20in%20a%20coloumn%20with%205%20unique%20values%20but%20the%20excel%20auto%20filter%20is%20able%20to%20fetch%20only%203%20values%20out%20of%205%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2270780%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
I have more than 10000 records in a coloumn with 5 unique values but the excel auto filter is able to fetch only 3 values out of 5
1 Reply

@shalinprasad 

I'd first check the range if all data are covered and if "unique" values are actually identical (no no-printable characters, etc) simply by something like =A5=A873