Cell formating for Excel 97

  • Thread starter Thread starter anita.mcdermott
  • Start date 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.
 
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.
 
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!
==============================================

"(e-mail address removed)"
Click to expand...
 
Back
Top