My formula is in B4 is:
{=SUM(IF(FREQUENCY(IF('Raw Data'!F$3:F$65000=D4,MATCH('Raw Data'!B$3:B$65000,'Raw Data'!B$3:B$65000,0)),ROW('Raw Data'!B$3:B$65000)-ROW('Raw Data'!B$3)+1),1))}
I used CTRL-SHIFT ENTER instead of just entering it, and it shows {}. If I don't use CTRL-SHIFT ENTER it will return a different answer so I just used it in my cell.
But my problem is, when I trnsferred it to my VBA code:
[VBA]Range("B4").Formula = "=SUM(IF(FREQUENCY(IF('Raw Data'!F$3:F$65000=D4,MATCH('Raw Data'!B$3:B$65000,'Raw Data'!B$3:B$65000,0)),ROW('Raw Data'!B$3:B$65000)-ROW('Raw Data'!B$3)+1),1))"[/VBA]
it returns a different answer, since the "{}" wasn't there.
I tried typing "{}" but my code just returns an error, how will I modify my VBA formula so it will return the correct answer?
Thanks!