Hi,

How to identify the duplicate values in same sheet. Eg. A1,A2,A3,A1.

Regards,

Hi,

How to identify the duplicate values in same sheet. Eg. A1,A2,A3,A1.

You can use CONDITIONAL FORMATTING to light up cells that are duplicates.

For column A, for instance:

1) Highlight column A
2) Open the Conditional Formatting window and apply a new custom rule with this formula:

=COUNTIF(A:A, A1)>1

The "advanced" filter option on the "Data" dropdown menu has the "unique records only". This feature will remove the duplicates from the list. Actually it "hides" the rows unless you opt to copy the data to a new location.

Hi,

Thank you for the solution.

one more clarification if the values are duplicate in the same rows; then how to enable those duplicate valuse in next rows.

Please elaborate... or attach a sample workbook demonstrating everything you're talking about. Mock it all up manually so we can see everything.