It's been a few months since I've last used an Array formula and I consider myself fairly well versed in them, but I can't figure this one out!
The array is fairly simple and I've identified the issue is with the IF section returning multiple values for each "True" result, instead of the expected single number so I'm only going to review that portion.
{=SMALL(IF(Sheet19!$C$2:$P$2=0,ROW($1:$14)),ROW($1:$1))}
Stepping through the formula I get to this stage:
The result I'd normally expect from this would be 1,2,3,4,5,6,7,8,9,10,11,12,, of which the small is currently picking the 1st smallest number.
However the evaluation is not working as I'd expect and giving the following on the next step
Any help appreciated!
The array is fairly simple and I've identified the issue is with the IF section returning multiple values for each "True" result, instead of the expected single number so I'm only going to review that portion.
{=SMALL(IF(Sheet19!$C$2:$P$2=0,ROW($1:$14)),ROW($1:$1))}
Stepping through the formula I get to this stage:
The result I'd normally expect from this would be 1,2,3,4,5,6,7,8,9,10,11,12,, of which the small is currently picking the 1st smallest number.
However the evaluation is not working as I'd expect and giving the following on the next step
Any help appreciated!