Forum Discussion
Dynamic array function error(#N/A) when file moved to excel 2016.
Dear all, Kindly I receive an error when moving file from 365 to 2016 i know it is not supported all i look for is a replacement to the formula i have written i have range of cells from $E$8:$E$382 ...
=OFFSET('PDR Evaluation'!$E$8,(ROUNDDOWN(COUNTA('PDR Evaluation'!$E$8:$E$382)*2%,0)+ROUND(COUNTA('PDR Evaluation'!$E$8:$E$382)*14%,0)+ROUND(COUNTA('PDR Evaluation'!$E$8:$E$382)*68%,0)+ROUND(COUNTA('PDR Evaluation'!$E$8:$E$382)*14%,0)),0,ROUNDDOWN(COUNTA('PDR Evaluation'!$E$8:$E$382)*2%,0))
I don't see why this formula would fail in Excel 2016, but I have to admit it doesn't make much sense to me either...
- may because i have slicers in the sheet and thus the range that is looking in is always changing ?