Excel - Go from ELSEIF, to a nested IF, then to ELSE -

    elseif numcol1 = numcol2             dim integer             = 14 33                 if cells(i, 6) <> "" , cells(i, 7) = ""                 msgbox "please indicate if subs allowed.", vbcritical                 cancel = true                 exit sub                 end if             next     else            'do 

if numcol1 = numcol2 valid (this counting number of values in each column) , should go else bit however, want check if cells next each filled in rather

e.g.

  2               2 col1            col2 value1          value1 value2          value2 

this valid, 2 above each column count of how many values in each column

  2               2 col1            col2 value1          value1 value2          (blank) (blank)         value2 

this not valid, though count still two, last value2 should in row above

a bit confusing, appreciated! thanks!

you need perform validity test every row. point out, counting values in each column unreliable.

add formula in third column. work:

=if(a1=b1,0,1) 

copy formula , paste down rows need evaluated.

now sum results of formulas. if sum greater 0, have invalid rows.