Forum Discussion
Help with a formula
Select File > Options > Formulas.
Scroll down to the section 'Error checking rules'.
Clear the check box 'Formulas which omit cells in a region'.
Click OK.
Thank you so much, I'm grateful for your knowledge. All of the formulas work in the way I want to display the data. In both G2 and H2 am getting an error "formula omits adjacent cells". When I choose to 'ignore error" it does remove the error, however I am not able to pull this down through the cells in the column. I have to go to each cell individually to ignore the error. Is there a way to fix this?
Select File > Options > Formulas.
Scroll down to the section 'Error checking rules'.
Clear the check box 'Formulas which omit cells in a region'.
Click OK.
This worked perfectly. Thank you so much!!!