Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can i stop data being repeated within a column?
I have a list of contract numbers relating to application numbers or
payments. they are in the format nnnnnnan or nnnnnnpn. The columns are fixed to this format only. If they are entered with the a or p in the wrong place or if they have been left out completely an error message will appear to alert the user. I want to know how to alert the user if they enter an application or a payment number that has already been entered. ie if they enter 022079a4 but that same application has been entered else where in the column. If anyone has a step by step suggestion that would be very helpful. And if its a formula should i put it at the top of the column or where. All suggestions gratefully accepted. Hope you can help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Prevent Hidden Column data from being copied/pasted? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |