limit column entries

B

Boenerge

Is it possible to block enteries in a column if a certain amount of text
entries has been reached e.g. if you only want 3xE & 2xL entries?
 
B

Boenerge

The 3xE & 2xL refer to the limit of entries of that particular text type in a
column. The text refers to specific shifts (E-early, L-late). So I only
want to enter 3 early shifts and 2 late shifts and block and further entries
of these shift types. Hope this clears things up a bit.
Boenerge
 
B

Biff

Hi!

Assume you want to limit the range A1:A20 to a maximum of 3 E's or 2 L's.

Select the range A1:A20
Goto Data>Validation
Allow: Custom
Formula: =AND(COUNTIF(A$1:A1,"E")<=3,COUNTIF(A$1:A1,"L")<=2)

Biff
 
Top