Select the range of cells in which you wish to eliminate duplicate values. Before attempting to remove duplicates, remove any outlines or subtotals from your data.
Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates. ...
Click OK.
To select multiple columns, hold down the Ctrl key. What exactly is this? Remove Duplicates from the menu by right-clicking on the specified column header. You can also use the Remove Rows Remove Duplicates command from the Home tab.
Choose the A1:C10 range.
Select Conditional Formatting from the Styles group on the Home tab.
Select Duplicate Values, Highlight Cells Rules.
Click OK after selecting a formatting style.
Choose the two columns of data you want to compare. Choose Highlight Cells Rules, then Duplicate Values from the Conditional Formatting drop down on the Home tab, in the Styles grouping. Select the colours you desire in the Duplicate Values dialogue box and click OK. Unique is an option as well.
Learner's Ratings
4.7
Overall Rating
84%
9%
5%
2%
0%
Reviews
M
Md Mujahidul islam
5
This is a very good course.
M
Md Masud Rana
5
Good job
M
MD Yasin Khan
5
very helpfully for me thanke you learn vern team member
A
Abrar Hossen
5
I am happy for this course ....love you...I want to more course in bangla tutorial...from Bangladesh
Share a personalized message with your friends.