ExcelBanter - Block entries

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Block entries (https://www.excelbanter.com/excel-worksheet-functions/25002-block-entries.html)

Boenerge

Block entries

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

JE McGimpsey

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.

Boenerge

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.

"JE McGimpsey" wrote:

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.

All times are GMT +1. The time now is 02:06 AM.