I am trying to work out how I can replace RICI notation with names in my worksheet in a formula array . This works.
Range("M3").Select
Selection.FormulaArray = _
"=IFERROR(INDEX(Expense2, MATCH(0,IF(ISBLANK(Expense2),1,COUNTIF(R2C13:R[-1]C, Expense2)), 0)),"""")"...