WorksheetFunction.Percentile - Array Formula

[Fjcosta]

Hello there,

I'm trying to get Percentile Formula within VBA in order to get a percentile by item and date. The excel Formula is the following:

{=Percentile(IF(($A$2:$A$100=$D2)*($B:$B=E$1),$D:$D,""),0.9)}

I've Tried the obvious with application.worksheetfunction.percentile but, obviously without sucess.

Can you help in this one?

Thanks in advance.

Fernando Costa