Help with OFFSET statement needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX - MATCH - OFFSET By Reference 2
relative offset to a named cell 3
Mapping integers to strings 5
Help needed 0
SUMIF with OFFSET 5
Sum every Nth Row (almost working) 1
Use vlookup within offset? 4
Countif issue 3

Back
Top