Update existing formula to read any cell with a value/is not blank

[lichldo]

I have this formula that pull from a set of data only cells that contain a dash

=FILTER('Billing Plans'!H:I,ISNUMBER(SEARCH("-",'Billing Plans'!H:H)))

However, I want to repurpose the formula to include ALL cells in that range, not just cells with "-", and just exclude cells that are blank

Can the same formula be modified to accomplish that?

 

[Fluff]

How about

=FILTER('Billing Plans'!H:I,'Billing Plans'!H:H<>"")

 

[lichldo]

How about

=FILTER('Billing Plans'!H:I,'Billing Plans'!H:H<>"")

Hello thank you

That gives me a #SPILL error

Maybe it would help to only read the range H4:H30 and I4:I30 on my sheet called Billing Plans?

 

[Fluff]

The error means you do not have enough empty cells below where you put the formula.

 

[lichldo]

The error means you do not have enough empty cells below where you put the formula.

I understand. the way I have this sheet structured I cannot make any more empty cells. There is enough room for the data it will pull, its just not endlessly empty in those columns. thats why i suggest maybe the formula only read the range H4:H30 and I4:I30 on my sheet called Billing Plans as thats only where data is ?

 

[Fluff]

You can changes the ranges to the rows you want, not a problem.

 

[lichldo]

You can changes the ranges to the rows you want, not a problem.

can you help how to say in formula please?

 

[Fluff]

You just the H:H as you posted in post#5 & similar for the H:I range H4:I30

 

[lichldo]

You just the H:H as you posted in post#5 & similar for the H:I range H4:I30

im sorry that just gives a #VALUE! error?

 

[Fluff]

In that case what is your current formula?