Forum Discussion
Help - Formula works in one sheet but not another?
I have a formula which works great in one sheet but not in any other sheets within the same workbook. I have tried both copy and pasting into a new sheet and retyping the formula. The formula is ...
This is an array formula, which must be entered using control+shift+Enter rather than just Enter.
JKPietersethank you for the reply, but this hasn't helped, it still returns zero and in the first sheet where it does work I only used Enter.