Checking for duplicates
You're almost done checking this report.
The last thing you need to do is check it for duplicate entries.
Latihan ini merupakan bagian dari kursus
Format Bersyarat di Google Sheets
Instruksi latihan
- Select the range that contains the dates and add conditional formatting with the Default green background using a
COUNTIFstatement to highlight any dates that occur more than once.- When fixing the range for the first criteria in the function, use
$s to fix the row numbers, but don't fix the column letters.
- When fixing the range for the first criteria in the function, use
Latihan interaktif langsung
Ubah teori menjadi aksi dengan salah satu latihan interaktif kami
Mulai latihan