Topic: [Did You Know] - Identifying Duplicate Values in a Spreadsheet (Read 194 times)
Definitely useful for all the managers but I guess they already know it..
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:
- "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,
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,
Jump to: