none
excel formula help RRS feed

  • Question

  • I updated a range in excel now it won't calculate the value correctly

    original formula: =IFERROR(ABS(INDEX(Template,4,SMALL(IF(Template!$B$17:$JK$17=$M$4,COLUMN(Template!$B$17:$JK$17)+1),ROW(1:1))+6)),"")

    updated formula:
    =IFERROR(ABS(INDEX(Template,4,SMALL(IF(Template!$B$17:$NH$17=$M$4,COLUMN(Template!$B$17:$NH$17)+1),ROW(1:1))+6)),"")

    it gives me the incorrect values for the updated formula unless I key F9, but then it deletes the formula
    • Moved by litdev Wednesday, June 21, 2017 5:20 PM
    Wednesday, June 21, 2017 3:40 PM

Answers