|
Title: [Did You Know] - Identifying Duplicate Values in a Spreadsheet Post by: Dr.Lecter on April 13, 2018, 07:26:09 AM Hello, :D
This is reason why i create topic!!! (https://bitcointalk.org/index.php?topic=3292271.msg34349045#msg34349045) for example, i have some Duplicate Values in a spreadsheet like this: https://i.imgur.com/ZlWW492.png So, how to find Duplicate Values? 1. Select your data => Click Format > Conditional formatting https://i.imgur.com/7zTs25v.png 2. From the: - "Format cells if..." dropdown menu select "Custom formula is:", and write: Code: =countif(A:A,A1)>1 - "Formatting style": choose the color you want. ( i choose red background) =>> "Done" https://i.imgur.com/wiipRWu.png Now you have a result (red is the Duplicate Values) : https://i.imgur.com/Z0ZFKLP.png "aralzain17" vs "aralzajn17" --------------------------------------- If you have a big data in spreadsheet: install add-on "Sort by color" : https://i.imgur.com/hmsPRtk.png type : "Sort by color" => press Enter => "+Free" https://i.imgur.com/fRAWpfv.png after finish, Choose column which you want to find Duplicate Values ( i choose column B to check profile link) ). Click to Add-ons => sort by color => sort by cell color. you got the Duplicate Values on Top or Bottom: https://i.imgur.com/b0pnKfO.png Cheers, ;D ;D ;D Title: Re: [Did You Know] - Identifying Duplicate Values in a Spreadsheet Post by: ubercool on April 16, 2018, 02:29:48 PM Definitely useful for all the managers but I guess they already know it.. ;)
|
