How to Find and Remove Duplicates in Google Sheets 

=countif(A1:A,A1)>1

How do you get the first entry to be highlighted?

Could you set that the last cell of the condition will become green too? like B9 and B16 and C16 and D14 etc? I mean, if they are still white, and they are at like row 1000, I can't tell if it's duplicated unless I scroll back to the previous rows looking for green. In some cases, I prefer the one who use the spreadsheet is noticed that he/she is entering a duplicated data.

1:54 here what to do if i want to delete the New entireties instead of the previous. Thanks

Thank you. You saves a lot of time 🎉

Thanks for sharing

infinite thanks bro.

Excellent Video!

This is a pain and I bailed 30 seconds into the video. The label should be "Weird and Obscure Way to Remove Duplicates"

not working

thanks bro

=countif(E1:E,E1)>1

=countif(B1:D,B1)>1

I hate Macs and I hate Google products. Trying to be different and utterly worthless. This didn't even work.