route217
asked on
Macro to copy array formula down column B from Cell B8 onwards
Hi Experts Using Excel 2013
How would you right a macro to copy the following array formula down column B8 onwards until row 300...worksheet "test1"
=IFERROR(INDEX('Unique List'!$B$2:$B$2000,SMALL(I F('Unique List'!$A$2:$A$2000=$B$3,RO W('Unique List'!$A$2:$A$2000)-ROW('U nique List'!$A$2)+1),ROWS(B$8:B8 ))),"")
How would you right a macro to copy the following array formula down column B8 onwards until row 300...worksheet "test1"
=IFERROR(INDEX('Unique List'!$B$2:$B$2000,SMALL(I
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
could you kindly shed some light here please...
https://www.experts-exchange.com/questions/28964330/Cannot-get-macro-to-auto-fill-correct-number-of-entries.html