Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Aprenda Removing Duplicates | Sorting, Filtering and Cleaning Data
Google Spreadsheets
course content

Conteúdo do Curso

Google Spreadsheets

Google Spreadsheets

1. Introduction to Google Sheets
2. Formatting of Cells and Ranges
3. Advanced Formatting of Cells
4. Sorting, Filtering and Cleaning Data
5. Creating Charts
6. Basic Functions
7. Logical Functions
8. Collaboration and Security

book
Removing Duplicates

Removing Duplicates is used to find and remove duplicate entries, which is especially useful when working with data that contains duplicate rows or values.

Why Rows 2 and 4 Were Not Removed

Rows 2 and 4 contain unique data combinations, despite having the same values in the Name, Department, Salary columns. While the values in row 2 match those in row 4, the Employee ID is different. Since they do not match completely, they were not removed as duplicates.

You have an employee dataset in Google Sheets and want to remove duplicate records based on the Employee ID column. How should you proceed?

You have an employee dataset in Google Sheets and want to remove duplicate records based on the Employee ID column. How should you proceed?

Selecione a resposta correta

Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 4. Capítulo 8
We're sorry to hear that something went wrong. What happened?
some-alt