How to delete the data in column vise

[ajmal pottekattil yoousuf]

How to delete the data in column vise.

please refer to the video attached.

in conditional formatting duplicate value is colored.

in blank cell also colored.

[#2]

@ajmal pottekattil yoousuf 

Many roads lead to Rome and even more solution methods in Excel :).

Filter for unique values or remove duplicate values

this link include a video

Find and remove duplicates

Sometimes duplicate data is useful, sometimes it just makes it harder to understand your data. Use conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you want to remove them.

Remove duplicates with UNIQUE function

Syntax: =UNIQUE(array,[by_col],[exactly_once])

[#3]

@NikolinoDE 

Why are the blank spaces showing duplicates?

[#4]

@ajmal pottekattil yoousuf 

How to remove duplicates but keep blank rows in Excel?

How to remove duplicates but keep rest of the row values in Excel? with VBA

[#5]

@NikolinoDE@ajmal pottekattil yoousuf

My one value is present in the "Cell Number: F4" other value is present in the " Cell Number: DS19 "

is it possible to remove the duplicate?