I have an array formula that for some reason keeps emptying the cells below it and then filling again, even when no changes were made (see column E). This is problematic as I use the TRUE/FALSE as a criteria to copy information into a new tab hence this copied data set also fluctuates.
Has anyone come across this before?
*I should mention I that I am using iterative calculations which I feel may be playing a part in the issue
Thanks in advance!