check for previous entry

[MichaelCasper]

I use column "D" for entering invoice numbers.How can I have Excel lock at
all previous enteries to see if I am duplicating an entry on any other row of
column "D"

 

[Max]

You could apply data validation on that col D

Select col D
Click Data > Validation
Allow: Custom
Formula: =COUNTIF(D,D1)<2
Click OK

Test it out ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik

 

[smartin]

I use column "D" for entering invoice numbers.How can I have Excel lock at
all previous enteries to see if I am duplicating an entry on any other row of
column "D"

Hello,

Max gave a good solution. Something else you could try is conditional
formatting:

Place the cursor in D1 and click the D column header to select the
entire column.

Choose Format | Conditional Formatting and fill in the options as follows:

Condition1:
change to Formula is
=COUNTIF(D,D1)>1

Click the Format button and choose something eye-catching, e.g., yellow
shading with red font.