Macro to populate formula based on value in cell M2
Posted on 2016-08-19
Hi Experts Using Excel 2013
need a macro to populate down the following array formula down column A starting at Cell A8.....
So if the value in cell M2 is 74 then populate down starting at A8 and incl A8 74 times if Cell m2 is 84 then so on..
=IFERROR(INDEX('Unique List'!$B$2:$B$2000,SMALL(IF('Unique List'!$A$2:$A$2000=$B$3,ROW('Unique List'!$A$2:$A$2000)-ROW('Unique List'!$A$2)+1),ROWS(B$8:B8))),"")