Software

Ask something
Discussion Locked

Preventing duplicate records Excel 2003

0 helpful
5 replies

by edudley

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a spreadsheet that one of the columns is P.O. numbers. I want to make sure as I am entering data that I do not key in the same P.O. number more than once. I looked at data filters with unique records but that did not look like it would help. What I would like to have it do, is when a duplicate is keyed a warning would show.
Thanks
Edie

5 replies

by sundaram.nk

goto the first cell in that column and from data->validation->Settings
Select Custom in the Allow and in the formula
type =COUNTIF(A$1:A$20,A1)=1 (replace A with column of PO with the appropriate excel column (A, B, C etc)). Here it is validating for duplicates in Column A starting from the first row to 20th row. Copy and paste this value for the range.
In the error alert tab, enter for Title "Duplicate PO No" or any appropriate error message as applicable.

This discussion is closed to new replies.