Forum Discussion
How to find the duplicate in column vise
Here the two instruments Name are present both "Torque " Family and "Transducer" Family
Please Guide to how to find the duplicate.
5 Replies
Select the entire range.
On the Home tab of the ribbon, select Conditional Formatting > Highlight Cells Rules > Highlight Duplicates..., then click OK.
I am Trying to remove the duplicate it's showing like this.
The Data > Remove Duplicate command works for duplicates within a column only.
How do you determine which of the duplicate values should be removed?
And do you just want to clear the cells with duplicate values, or should the cells below be moved up?
