Mar 06 2023 11:33 PM
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.
Mar 07 2023 02:18 AM
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])
Mar 07 2023 02:41 AM
Why are the blank spaces showing duplicates?
Mar 07 2023 02:50 AM - edited Mar 07 2023 02:50 AM
Mar 07 2023 02:50 AM - edited Mar 07 2023 02:50 AM
@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?