| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoice Number duplicate Check
I have a spreadsheet with a bunch of invoices. Is there a way for me to
check to see if any duplicates exist as i type in the cell. example would be cell a2 has invoice number 12345, then i type in cell a3 12345 and hit enter and a messge comes up saying invoice number exists. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Invoice Number duplicate Check
See:
http://cpearson.com/excel/NoDupEntry.aspx In article , JOSEPH WEBER wrote: I have a spreadsheet with a bunch of invoices. Is there a way for me to check to see if any duplicates exist as i type in the cell. example would be cell a2 has invoice number 12345, then i type in cell a3 12345 and hit enter and a messge comes up saying invoice number exists. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Invoice Number duplicate Check
http://www.contextures.com/xlcondfor...html#DupColumn
http://v.mcomet.com/detail/3348431/ HTH, Ryan-- -- RyGuy "JE McGimpsey" wrote: See: http://cpearson.com/excel/NoDupEntry.aspx In article , JOSEPH WEBER wrote: I have a spreadsheet with a bunch of invoices. Is there a way for me to check to see if any duplicates exist as i type in the cell. example would be cell a2 has invoice number 12345, then i type in cell a3 12345 and hit enter and a messge comes up saying invoice number exists. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| invoice toolbar for invoice calcuation and assign number | Excel Discussion (Misc queries) | |||
| How do I assign an invoice number using the invoice toolbar? | Excel Worksheet Functions | |||
| How can I check for a duplicate number in a column in Excel? | Excel Discussion (Misc queries) | |||
| How do I generate a new invoice number when creating new invoice? | Excel Discussion (Misc queries) | |||
| How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
Linear Mode
