I have six columns titled B, M, L, A, S, E.

What are the *actual* columns being used? Are the columns a contiguous
range?

Is the only allowable entry a X?

--
Biff
Microsoft Excel MVP


"JStiehl" wrote in message
...
I have six columns titled B, M, L, A, S, E. I have a data validation that
prohibits X's from being entered under more than 3 of the 6 columns per
row.
I need another data validation that prohibits users from entering their 3
X's
under the columns B, L, and S together (all other combinations are fine).
Any help is much appreciated.