| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique numbers entered once only
I am having a problem with a client using Excel to record receipts issued
to her clients. Looking at the data she has entered it appears that she has entered some receipts twice. Is there any way one can enforce unique integrity on a data column so that if the operator tries to enter the same number it will be rejected or ring warning bells ? If you can offer any suggestions it would be much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In spread sheet the numbers entered as whole numbers become decim | Excel Worksheet Functions | |||
| how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) | |||
| All Numbers entered divided by 100,000,000,000! | Excel Discussion (Misc queries) | |||
| How to format numbers that are already entered? | Excel Worksheet Functions | |||
| Numbers entered change to 0 | Excel Discussion (Misc queries) | |||
Threaded Mode
