| 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 | |||
Linear Mode
