How to delete the data in column vise

Iron Contributor

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.

4 Replies

@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])





Why are the blank spaces showing duplicates?

@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?