Checking for duplicates
You're almost done checking this report.
The last thing you need to do is check it for duplicate entries.
Este exercicio faz parte do curso
Formatação Condicional no Google Sheets
Instruções do exercicio
- 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
exercicio interativo prático
Transforme teoria em prática com um dos nossos exercicio interativos
Iniciar exercicio