Duplicate Check

  • Thread starter Thread starter RUSS
  • Start date Start date
R

RUSS

I have a problem with determining if a unique serial number currently exists
in a spreadsheet.

I have set up a workbook where Sheet1 acts as a data entry point and
contains a macro associated with a button that takes the entered data and
transfers it to Sheet2 to the next available empty row thereby adding it to
what amounts to a database of information.

The problem I am having is, as stated above, determining if there is a
currently existing number matching the one which is about to be placed into
the "database."

I added a formula on Sheet1 to check for duplicates as follows:

=IF(COUNTIF(named_range, C8)>1, "STOP", " ")

Where "named_range" is the range of data on Sheet2 that is compared to the
soon to be entered data in cell C8 on Sheet1.

The formula works - if, as you can see, there is a duplicate entry already
in existance on Sheet2.

Can someone please help me with a formula that will work the way I need it
to?
 
Hi Russ,

How exactly do you want it to work? You said the formula
works if there is a dup so it's done it's job.

Biff
 
The formula works if there is ALREADY a duplicate in the data area - I need
a formula to check the about to be entered serial number against the already
existing data so that I don't enter the new data into the the data area
(Sheet2) where it will become a duplicate.

Please Help
Thanks, Russ
 
It's checking the existing database to see if there are >1 instances, right?
Why not change the formula to >0 ?

chris
 
Hi Russ,

Sorry, but I'm not following you here.
The formula works if there is ALREADY a duplicate in the
data area
Click to expand...
I don't enter the new data into the the data area(Sheet2)
Click to expand...

How many data areas are there?

Here's how I read your description:

On sheet1 in cell C8 you enter a value. You use the IF
COUNTIF formula to see if the value in C8 is already
entered in the DB on sheet2? Please tell me what I'm
missing or provide greater detail.

Biff
 
Back
Top