On Sep 3, 4:51*pm, GS wrote:
Don Guillett used his keyboard to write :



Insert a row at the top and put this in row2 and copy down
=IF(AND(COUNTIF(B2:H2,""&0),a1<"x"),"x","")

This does not place x for set#3 nor set#6 of the OP's sample data. It
needs to test both rows to determine the action to take on one or the
other.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Did you insert a row at the top. I can send a file or you can send me
yours
dguillett1 @gmail.com