Forum Discussion

Helen15's avatar
Helen15
Copper Contributor
Apr 04, 2022
Solved

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...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Apr 04, 2022

Helen15 

If you have Microsoft 365 or Office 2021:

 

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

  • Helen15's avatar
    Helen15
    Copper Contributor
    Apr 04, 2022
    thank you but it says SPILL ?? as my ss is much bigger than the example i gave. Any idea?
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Apr 04, 2022

      Helen15 

      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.