Is it possible to block enteries in a column if a certain amount of text entries has been reached.
B Boenerge May 5, 2005 #1 Is it possible to block enteries in a column if a certain amount of text entries has been reached.
J JE McGimpsey May 5, 2005 #2 One way: Assume that the column is column A, and you want a maximum of 10 entries. Select the column. Choose Data/Validation. Allow: Custom Formula: =COUNTA(A:A)<=10
One way: Assume that the column is column A, and you want a maximum of 10 entries. Select the column. Choose Data/Validation. Allow: Custom Formula: =COUNTA(A:A)<=10
B Boenerge May 5, 2005 #3 Would this also work if you only wanted certain text blocking if it reached a level but would still aloow other text to be entered.
Would this also work if you only wanted certain text blocking if it reached a level but would still aloow other text to be entered.
