Forum Discussion
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...
Like in attached
thank you but it says SPILL ?? as my ss is much bigger than the example i gave. Any idea?
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.