We have a super cool tool inbuild in windows 10 and that is Snipping ToolThe snipping tool is easy to use and user-friendly tools with…
Remove duplicate values. Select the range of cells that has duplicate values you want to remove.
Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.
To highlight duplicate values, click Home > Conditional Formating > Highlight cells rules > Duplicate Values