Theres a problem with removing duplicates and leaving the only one

%3CLINGO-SUB%20id%3D%22lingo-sub-1281108%22%20slang%3D%22en-US%22%3ETheres%20a%20problem%20with%20removing%20duplicates%20and%20leaving%20the%20only%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281108%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20try%20to%20remove%20duplicates%20%2C%20while%20using%20filter%2Cexcel%20marks%20all%20my%20numbers%20as%20duplicates%20or%20on%20another%20way%20it%20kinda%20works%2Cbut%20still%20one%20number%20is%20duplicated%202%20or%203%20times%3C%2FP%3E%3CP%3EP.S%20while%20using%20filter%20%2Cwhen%20the%20information%20pops%20out%20%2Cit%20shows%20good%20numbers%2C%20but%20after%20clicking%20okey%2C%20the%20value%20changes%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1281108%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281122%22%20slang%3D%22en-US%22%3ERe%3A%20Theres%20a%20problem%20with%20removing%20duplicates%20and%20leaving%20the%20only%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281122%22%20slang%3D%22en-US%22%3EI%20have%20copied%20the%20command%20from%20another%20line%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281130%22%20slang%3D%22en-US%22%3ERe%3A%20Theres%20a%20problem%20with%20removing%20duplicates%20and%20leaving%20the%20only%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281130%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F609048%22%20target%3D%22_blank%22%3E%40Arnelis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When I try to remove duplicates , while using filter,excel marks all my numbers as duplicates or on another way it kinda works,but still one number is duplicated 2 or 3 times

P.S while using filter ,when the information pops out ,it shows good numbers, but after clicking okey, the value changes

2 Replies
I have copied the command from another line