Thread: Block entries
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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

In article ,
"Boenerge" wrote:

Is it possible to block enteries in a column if a certain amount of text
entries has been reached.