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?

This is multiposted.

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

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Boenerge" wrote in message
...
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?

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

"Earl Kiosterud" wrote:

This is multiposted.

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

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Boenerge" wrote in message
...
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?

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 DataValidation
Allow: Custom
Formula: =AND(COUNTIF(A$1:A1,"E")<=3,COUNTIF(A$1:A1,"L")<=2 )

Biff

"Boenerge" wrote in message
...
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

"Earl Kiosterud" wrote:

This is multiposted.

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

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Boenerge" wrote in message
...
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?

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

"Biff" wrote in message
...
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 DataValidation
Allow: Custom
Formula: =AND(COUNTIF(A$1:A1,"E")<=3,COUNTIF(A$1:A1,"L")<=2 )

Biff