SOLVED

# Help with a formula to miss a cell that is zero

Occasional Contributor

# Help with a formula to miss a cell that is zero

I am having problems with this formula, I need it to only pick up the code that has a value in cell B. But my formula in column F doesn't work as it duplicates the the cell underneath (as highlighted in red). Does anyone have any suggestions ?

many thanks

6 Replies

# Re: Help with a formula to miss a cell that is zero

If you have Microsoft 365 or Office 2021:

=FILTER(A1:A11,B1:B11>0)

# Re: Help with a formula to miss a cell that is zero

thank you but it says SPILL ?? as my ss is much bigger than the example i gave. Any idea?

# Re: Help with a formula to miss a cell that is zero

1) Adjust the ranges as needed, e.g. =FILTER(A1:A1000,B1:B1000>0)

2) Make sure that the cells below the cell with the formula are empty.

best response confirmed by Helen15 (Occasional Contributor)
Solution

Like in attached

# Re: Help with a formula to miss a cell that is zero

@Sergei Baklan thank you so much. It works perfectly, I didn't be realise that underneath the formula needs to be empty. Thank you again really works perfectly.

# Re: Help with a formula to miss a cell that is zero

@Helen15 , you are welcome