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
83%
10%
4%
3%
0%
Reviews
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
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
Share a personalized message with your friends.