G gary Nov 25, 2014 #1 What formula will determine whether a1, b1, c1, d1, e1, f1 and g1 are all empty?
C Claus Busch Nov 25, 2014 #2 Hi Gary, Am Mon, 24 Nov 2014 16:50:03 -0800 (PST) schrieb gary: What formula will determine whether a1, b1, c1, d1, e1, f1 and g1 are all empty? Click to expand... try: =COUNTA(A1:G1)=0 Regards Claus B.
Hi Gary, Am Mon, 24 Nov 2014 16:50:03 -0800 (PST) schrieb gary: What formula will determine whether a1, b1, c1, d1, e1, f1 and g1 are all empty? Click to expand... try: =COUNTA(A1:G1)=0 Regards Claus B.