ExcelBanter - Help with OFFSET statement needed

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help with OFFSET statement needed (https://www.excelbanter.com/excel-worksheet-functions/107380-help-offset-statement-needed.html)

tom

Help with OFFSET statement needed

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.

Toppers

Help with OFFSET statement needed

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.

tom

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.

All times are GMT +1. The time now is 09:31 AM.