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.6
Overall Rating
81%
11%
5%
3%
0%
Reviews
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Share a personalized message with your friends.