There's probably an easier way but this should get the job done:
Consider haivng an integer variable, one for each of the values fro
1-7 to store the occurance of the particular value in a row.
At the end of the row, if any of the variables have a value of 4 o
greater then delete the row.
of course this should be looped for each row and the variables ar
reset at the beginning of a new iteration.
Thats how I would do it. hope it helps
--
bail
-----------------------------------------------------------------------
bails's Profile:
http://www.excelforum.com/member.php...fo&userid=3615
View this thread:
http://www.excelforum.com/showthread.php?threadid=55943