This post is written to accompany the YouTube video showing how to identify duplicates in your Google Sheet.
Conditional Formatting Function – For starting in cell A2
IF statement – Written as if it started in row 2 and looks at three columns
=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2)>1, "Duplicate", "")
Live examples in Sheets
Using a plugin
As an alternative to the options above, you may want a plugin to do the heavy lifting for you. I like to use a plugin called Power Tools. This will give you a menu option with, among other things, several options to deal with duplicates. You can use the plugin to combine or remove duplicated rows.