How to remove duplicate cells in Google sheets

Configurare noua (How To)

Situatie

If you have a lot of duplicated in your google sheets file this is how you can remove all at once.

Solutie

Select the cells you want to check for duplicates. Go to the Data tab, select Data Cleanup, and pick Remove Duplicates.

If your data has headers, check that box at the top of the pop-up window. Then, confirm the columns you want to review and click Remove Duplicates.

You’ll see a message letting you know how many duplicates were found and removed. Select OK to close the window.

Tip solutie

Permanent

Voteaza

(10 din 13 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?