Forum Discussion

Ismailx's avatar
Ismailx
Copper Contributor
Feb 06, 2023

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 ...
excel
  • Ismailx's avatar
    Ismailx
    Copper Contributor
    Feb 08, 2023
    =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))
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Feb 08, 2023

      Ismailx 

      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...

      • Ismailx's avatar
        Ismailx
        Copper Contributor
        Feb 08, 2023
        may because i have slicers in the sheet and thus the range that is looking in is always changing ?

Resources