[Did You Know] - Identifying Duplicate Values in a Spreadsheet

[Dr.Lecter]

Hello,

This is reason why i create topic!!!

for example, i have some Duplicate Values in a spreadsheet like this:



So, how to find Duplicate Values?

1. Select your data => Click Format > Conditional formatting



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"


Now you have a result (red is the Duplicate Values) :



"aralzain17" vs "aralzajn17"

---------------------------------------

If you have a big data in spreadsheet:

install add-on "Sort by color" :



type : "Sort by color" => press Enter => "+Free"



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:




Cheers,

[1714672528]

1714672528

[1714672528]

1714672528

[1714672528]

1714672528

[ubercool]

Definitely useful for all the managers but I guess they already know it..