How to find the duplicate in column vise

[ajmal pottekattil yoousuf]

Here the two instruments Name are present both "Torque " Family and "Transducer" Family

Please Guide to  how to find the duplicate.

[#2]

@ajmal pottekattil yoousuf 

Select the entire range.

On the Home tab of the ribbon, select Conditional Formatting > Highlight Cells Rules > Highlight Duplicates..., then click OK.

[#3]

@Hans Vogelaar 

I am Trying to remove the duplicate it's showing like this.

[#4]

@ajmal pottekattil yoousuf 

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?

[#5]

I needed only to Just Clear the Duplicate Value.

[#6]

@ajmal pottekattil yoousuf 

How do we decide which of the duplicate values should be removed?