split formula array

[kelvin_9]

Hi All,

is it possible to(or how can i) run this formula in macro?

    Range("B52").Select
    Selection.FormulaArray = _
        "=SUM((FREQUENCY(IFERROR(MATCH(data!R2C1:R20000C1,data!R2C1:R20000C1,0),0)*(INT(data!R2C5:R20000C5)=RC1),IFERROR(MATCH(data!R2C1:R20000C1,data!R2C1:R20000C1,0),0)*(INT(data!R2C5:R20000C5)=RC1))>0)*1)-1"
        Selection.AutoFill Destination:=Range("b52:b" & Range("a" & Rows.Count).End(xlUp).Row)

thank you very much for your guidance

 

[RoryA]

This is part of the same question you have already posted, and we do not allow duplicate threads, so this is now closed.