Forum Discussion
How to delete the data in column vise
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.
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
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?
@NikolinoDEajmal_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?
