Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
check for previous entry
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" |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
check for previous entry
You could apply data validation on that col D
Select col D Click Data Validation Allow: Custom Formula: =COUNTIF(D:D,D1)<2 Click OK Test it out .. -- Max Singapore http://savefile.com/projects/236895 Downloads:17,500 Files:358 Subscribers:55 xdemechanik --- "MichaelCasper" wrote: 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" |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
check for previous entry
MichaelCasper wrote:
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:D,D1)1 Click the Format button and choose something eye-catching, e.g., yellow shading with red font. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to check previous cells for same data and return Y/N | Excel Worksheet Functions | |||
How to check previous entries in column for same contents | Excel Worksheet Functions | |||
restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
Entry into check box dependent on other check box. | Excel Worksheet Functions | |||
How to "repeat previous entry" ? | Excel Worksheet Functions |