Is there anyway I can do the below formula without it being an array formula?
Code:
=(MIN(IF('Data'!$A$5:$A$50000=$C$8,IF('Data'!$I$5:$I$50000=C9,'Data'!$AC$5:$AC$50000))))
The reason I ask is because everyday I insert new rows into the 'Data' sheet so I can paste in the previous days data.
However this causes the ranges in my formulas to change, like this:-
Code:
=(MIN(IF('Data'!$A$50:$A$50045=$C$8,IF('Data'!$I$50:$I$50045=C9,'Data'!$AC$50:$AC$50045))))
I would be able to fix this by specifying the ranges as whole columns (e.g. A:A), but I am under the impression that this cannot be done in an array formula. Is this correct?
Any solution on how to get the ranges to stay the same or how to make the formula not an array would be much appreciated.
Thanks
Mark