Workaround for “Formula omits adjacent cells”
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 then the formula would give a similar error. So, without seeing your source data, it is difficult … Read more