Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Block entries
Is it possible to block enteries in a column if a certain amount of text
entries has been reached. |
#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 In article , "Boenerge" wrote: Is it possible to block enteries in a column if a certain amount of text entries has been reached. |
#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. "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge, update, and add only new entries into a list from other she | Excel Worksheet Functions | |||
valadation for dropdown won't allow enough entries | Excel Discussion (Misc queries) | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
count data but avoid double entries | Excel Worksheet Functions |