Google Sheets - Highlight Duplicate Data in a Column or Row
Learn how to use conditional formatting in Google Sheets to highlight cells with duplicate data.
To do a row instead of a column, use 1:1 to reference all of row 1, just like you use A:A to reference all of column A.
If you live in a country that uses a comma as a decimal separator, use semi-colons instead of commas.
Use an add-on to manage duplicate: • Remove Duplicates (with a Sheets Add-...
Learn more from Prolific Oaktree:
🌳 Next Video - Google Sheets | Sort and Filter by Color • Google Sheets - Sort and Filter by Color
🌳 Related Playlist - Google Apps | Full Tutorials - https://bit.ly/google-tutorials
#googlesheets #spreadsheets #duplicates
Watch video Google Sheets - Highlight Duplicate Data in a Column or Row online without registration, duration hours minute second in high quality. This video was added by user Prolific Oaktree 21 June 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 725,407 once and liked it 3.9 thousand people.