View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom tom is offline
external usenet poster
 
Posts: 570
Default Help with OFFSET statement needed

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

"Toppers" wrote:

what is your current formula?

"Tom" wrote:

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.