Forum Discussion
NotSoFastEddie
Apr 01, 2024Brass Contributor
Excel - How to store a value so it does not get used again
The user has to assign a unique value to a cell and make sure it does not get used again, as the input for the row ultimately becomes a unique identifier in a database. I am not sure if this is some...
m_tarler
Apr 01, 2024Bronze Contributor
NotSoFastEddie I don't understand the picture you included but you can use Data Validation to prevent mutliple copies of the same entry:
so if you try to enter the same value (e.g. 15) it will pop up a warning that it isn't allowed or any custom message you set under the 'Error Alert' tab of that menu.
Notice I use the COUNTIF( [fixed range using $$], [first cell in range] )