Block entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to block enteries in a column if a certain amount of text
entries has been reached.
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

limit column entries 4
can this be done? 10
Excel 2007 Is it possible to vary the column width between rows? 3
Help needed 0
entries disappear from my calander 1
Display information from other worksheet 1
check for previous entry 1
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1

Back
Top