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.
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?
- I needed only to Just Clear the Duplicate Value.
