If there's the possibility of invisible white spaces, formula blanks: ""
within the supposedly "blank" rows, use this heavier duty workhorse instead
in A2:
=IF(SUMPRODUCT(--(TRIM(B2:IV2)<"")),"x","")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---