An Excel formula is showing '#NAME?' One of my users has an external program (python, I believe) that builds up this Excel formula: INDEX(G$17:G$112,AGGREGATE(15,6,(ROW($G$17:$G$112)-ROW($G$17)+1)/($G$17:$G$112=-60),$A19)) and populates the spreadsheet - inside Excel it shows '#NAME?' and the error is 'This formula contains unrecognized text'. However, if you highlight the cell and hit enter, the formula parses ok, the error goes away and it returns the correct value. Any idea what may be happening?
Solved by S. A. in 30 mins