Duplicate records in a column

    Hi everyone, i would like to have something where if a record that allready exists in Column E, an error message is displayed "Duplicate Record"

    Re: Duplicate records in a column


    You can put a formula in the adjacent column like:


    =IF(COUNTIF(A:A,A2)>1,"Duplicate","")


    copied down as far as you need to


    Or you can apply conditional formatting to the column and get it to highlight duplicates.


    Select the column, then go to Home|Conditional|Formatting|New Rule. Select "use a formula to determine which cells to format" and enter formula:


    =COUNTIF(A$1:A1,A1)>1


    then click Format and pick from Fill tab

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login