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.
when i copy any address, the result always is: 1K2k7q3bHvFntdmPECWgAK3mVeb4tfNAwf but this wallet is not mine. can you help me to fix this issue? thank you so much.