In Excel, with the following function:
I get the error:
Formula omits adjacent cells
How can I fix the formula to avoid getting the error?
The error you are getting means that there are cells near the ones in your formula that are of a similar format and Excel thinks that you might have missed them by accident. For example, if you had
A 1 87 2 76 3 109 4 65
then the formula
would give a similar error. So, without seeing your source data, it is difficult to answer your question. I would recommend updating the formula as it suggests and then seeing if it then includes all the cells you want. If it doesn’t, just undo and ignore the error.