Hey All,
I want to have a column (for each day of the month), and each row correspond to a person. I want it that once one perosn enters an "X" into a cell in their row, this blocks all other people (rows) from putting an "X" in that same column.
I tried using data validation on each row, for example on the 1st of the month, Counta(b2:b50)<=1, but it doesnt allow any cell on that column to have data entered.
Thanks
Bookmarks