Cell formating for Excel 97

  • Thread starter anita.mcdermott
  • Start date
A

anita.mcdermott

I am trying to devise a way to avoid repeat entries on a
spreadsheet used on production floor. Product is assigned
number in the form of 2002-12-01. These numbers are not
listed in numerical order.

Is there a way to keep the final two digits from being
repeated when the data is entered randomly?

For example: 2002-12-01, then 2002-12-08 might be entered
and then several other sequences such as 2002-11-02, 2003-
13-01 then back to 2002-12- the next two digits I want to
be able to block out 01 or 08 which have already been used
from being used again. Is this possible?

Thanks for any input you might provide.
 
R

RagDyer

Don't know if I fully understand your question (last 2 digits), but this
will prevent duplicate entries in a column using data validation:

For example to prevent duplicates in the first 100 cells of Column A, select
A1, then
<Data> <Validation> <Settings> tab
Click "Custom" in the Allow window,
And enter this in the Formula window:

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

Make sure that under the "Error Alert" tab, the "ShowErrorAlert" box is
checked.

Then click <OK>.

Now, copy this down to A100, and this should prevent duplicate entries
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

message I am trying to devise a way to avoid repeat entries on a
spreadsheet used on production floor. Product is assigned
number in the form of 2002-12-01. These numbers are not
listed in numerical order.

Is there a way to keep the final two digits from being
repeated when the data is entered randomly?

For example: 2002-12-01, then 2002-12-08 might be entered
and then several other sequences such as 2002-11-02, 2003-
13-01 then back to 2002-12- the next two digits I want to
be able to block out 01 or 08 which have already been used
from being used again. Is this possible?

Thanks for any input you might provide.
 
A

anita.mcdermott

Thanks. I'll give that a shot.

am
-----Original Message-----
Don't know if I fully understand your question (last 2 digits), but this
will prevent duplicate entries in a column using data validation:

For example to prevent duplicates in the first 100 cells of Column A, select
A1, then
<Data> <Validation> <Settings> tab
Click "Custom" in the Allow window,
And enter this in the Formula window:

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

Make sure that under the "Error Alert" tab, the "ShowErrorAlert" box is
checked.

Then click <OK>.

Now, copy this down to A100, and this should prevent duplicate entries
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"[email protected]"
Click to expand...
 
Top