| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicates in a list
At one point in time I knew how to do this...
What formula do I use so excel won't allow me to put the same number in a column twice. I want to make sure I don't enter an invoice number more than once. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Duplicates in a list
See:
http://www.cpearson.com/excel/NoDupEntry.aspx -- Gary''s Student - gsnu200811 "jlojones821" wrote: At one point in time I knew how to do this... What formula do I use so excel won't allow me to put the same number in a column twice. I want to make sure I don't enter an invoice number more than once. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Both Duplicates from a list | Excel Discussion (Misc queries) | |||
| Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
| Single list ~ not duplicates | Excel Discussion (Misc queries) | |||
| Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
Linear Mode
