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:


    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:


    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!