Quote:
Originally Posted by GraemeSS
Problem is when I have formulas looking for data from the other sheets it assumes the next column has zero and I get a Div/0 error. How do I get the formula to remove the zero if there is no data?
|
I've not understood - could you attach a little spreadsheet with a few rows of data and as many sheets as necessary and few rows, some showing the formula (which formula?) working properly, some with the division by zero error?