Learn an easy way to find and remove duplicates in Excel.

Identifying duplicates data and eliminating it will help you keep your dataset clean and error free.

Here are the steps outlined in the YouTube video.

Highlight duplicate data (one column)
1) Select a column of data
2) Home tab
3) Conditional Formatting
-- Highlight Cells Rules
-- Duplicate values
4) Select "Duplicate" and colour.
5) OK

Remove Duplicate Rows
1) Select dataset
2) Data tab
3) Data Tools -- Remove Duplicates
4) Uncheck "My data has header".
5) OK

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ

свернуть