Help with OFFSET statement needed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 28 Aug 2006 19:27 GMT

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.

Reply to this Message

Toppers - 28 Aug 2006 19:31 GMT

what is your current formula?

> My column has a formula in it that returns text, or " ", depending on the
> data found.
[quoted text clipped - 3 lines]
>
> Any help would be appreciated.

Reply to this Message

Tom - 28 Aug 2006 19:38 GMT

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

> what is your current formula?
>
[quoted text clipped - 5 lines]
> >
> > Any help would be appreciated.

Reply to this Message