Google Sheets - 6 Ways to Highlight Duplicates ✅❌| Conditional Formatting Custom Formula | COUNTIF

Опубликовано: 10 Декабрь 2019
на канале: Coupler․io Academy

66,813

690

In this Google Sheets tutorial, you will learn 6 ways to highlight duplicates based on single and multiple conditions. Watch till the end to get a bonus feature from Google Sheets 🎁 We will use COUNTIF and custom formula in conditional formatting.
🎁Get your personal copy of the practice sheet: http://bit.ly/2MHQ1h5
😜Find a cheat sheet with ready-to-go formulas here: http://bit.ly/2RFvXAa
🔌Start using Coupler.io to streamline your data flows: http://l.rw.rw/coupler-duplicates

Highlight Duplicates in Google Sheets 🎨:
0:00 - Intro
0:39 - Highlight ALL DUPLICATES based on a SINGLE condition
4:10 - Highlight the whole row if a single value is a duplicate
4:48 - Highlight ALL DUPLICATES based on MULTIPLE conditions
7:57 - Highlight EXTRA DUPLICATES ONLY based on a SINGLE condition
10:10 - Highlight the whole row if a single value is an extra duplicate
10:25 - Highlight EXTRA DUPLICATES ONLY based on MULTIPLE conditions
11:58 - Bonus feature from GSheets 🎁Remove extra duplicates with a few clicks

💌 Contact Railsware to build your software product http://bit.ly/contactrailsware
🤝 Join Railsware team http://bit.ly/railswarecareers
✅ Subscribe to Railsware and learn the most efficient data analytics tools with us!