Help with OFFSET statement needed

T

Tom

My column has a formula in it that returns text, or " ", depending on the
data found.

I'm trying to do an "OFFSET" but keep getting an empty cell. How do I
filter out the " " cells in the column?

Any help would be appreciated.
 
T

Tom

Current formula in "Cell GG9" is =IF(GA9="","",IF(AND(GA9<=0,
GB9<=0),"Go",IF(AND(GA9>=100, GB9>=97),"Stopl",GG8)))

The column begins at GG8.

The Offset formula is =OFFSET(GG107,COUNT(GG109:GG264),0)

Tom
 
Top