How to make single selection in Google sheets dropdown menu?

Question

Google Sheets

We have a drop-down list with an object and the numbering of floors from 1 to 25. Is it possible to make it so that when choosing 1 floor (and further), the choice of this floor would be impossible in the future?

Answer 1

There is a simple and working way, but the problem is that a notification about the wrong choice will be displayed. You

need to set up a column of the remaining values

​​​​AND bind validation to this column

• Table Example