limit column entries

[Guest]

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?

 

[Earl Kiosterud]

This is multiposted.

I don't know what 3xE & 2xL means.

 

[Guest]

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

 

[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

 

[Tosca]

Nice trick - I'll file that for future use!