Скачать или смотреть Conditional Format - Highlighting duplicate or extra duplicate rows | Google Sheets Tutorial 45

In this lesson, We are going to explore:
0:00 Getting started.
0:23 How to highlight the duplicate rows?
1:52 How to highlight just the extra duplicate rows?
All explanations are simple and to the point.
Feel free to make your own copy of this spreadsheet:
https://docs.google.com/spreadsheets/...

#GoogleForEducation #GoogleWorkspace #GoogleSheets

If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded

Useful Link:
Ben Collins (Google Developer Expert & Data Analytics Instructor)
https://www.benlcollins.com/

Google Sheets training:
https://support.google.com/a/users/an...

The whole playlist link:
   • How to Use Google Sheets - Detailed Tutorial  

Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...

Sound from Zapsplat.com

Apple logo
https://iconscout.com/contributors/pi...

Windows logo
https://pixabay.com/it/users/

Welcome back to the fifth part of the Conditional format lesson.
Our mission is to highlight the duplicate values, then just extra duplicates.
To achieve that, we could use the COUNTIF formula.
We need to highlight all the properties located in Rome.
Start with the equal sign than the name of the formula.
Select the range.
Select the criterion.
Set the logic to make the formula return a true or false value.
Lock the range by adding the dollar sign.
Lock the column of the criterion.
To test the formula, drag it to the right, then down.
It should return TRUE to the whole row that has Rome.
Now, copy the formula.
Select the range.
Open the Conditional format sidebar.
Paste the formula.
And here is it.
To select just the extra duplicate, we change the range of the formula.
The range will be the cell itself.
Select Custom formula is, then paste the formula.
The first occurrence of Rome in the range doesn’t highlight.
It highlights just the extra duplicate.
That’s it, have fun. Thanks for watching.
If you like the video, please give us a thumbs up.
And subscribe to our channel.