![]() |
#4
|
|||
|
|||
![]()
Your unique numeric entries are entered into column A of sheet Working. And probably you have a header (a string) for this column too.
On some hidden sheet (e.g. Hidden), into some cell (e.g. A1) enter formula, which calculates next unique value, like Code:
=MAX(Working!$A:$A) +1 Code:
nNextID = Hidden!$A$1 Code:
nCurrID = Working!$A2 Create a Name (e.g lIDList), like Code:
lIDList = IF(nCurrID = "", nNextID, nCurrID) =lIDList Now, whenever you activate this Data Validation List on sheet working, when the cell has any ID value entered previously, this value is only option, and when the cell is empty, the next ID value is the option. You can also add another IF() level for lIDList, which checks is the active cell in column A, and when not, returns some error message instead ID value. |
Tags |
data validation, duplicate entries |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
everwisher | Mail Merge | 2 | 01-04-2019 04:50 AM |
Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? | jsisley | Excel | 1 | 07-21-2017 09:20 AM |
Duplicate entries | yourforester | Outlook | 1 | 11-15-2014 10:44 PM |
Calendar - Duplicate Entries | castow | Outlook | 0 | 02-05-2014 02:53 PM |
How Can I Flag Duplicate Date Entries? | tatihulot | Excel | 5 | 11-16-2012 12:19 AM |