Quote:
Originally Posted by Pecoflyer
Does the attached help?
be aware that the formula is an array formula to be committed with Ctrl+Shift+Enter
|
Here is my suggestion to fix the issue you are having. See the edits I made in blue. You could write the formula in column A all the way down and then hide column A then the edited formula would work no problem.
Let me know if this fixes the issue or if you need a different route.
Thanks