Hello,
I have realized that it is easy to use the averageifs in VBA to calculate the average, but when it comes to median, it is a bit tricky.
Could someone point me in the right direction as to how to go about implementing it?
Please see the attached file. There are two conditions that need to be applied on median.
condition 1) users will choose a specific period to calculate, and 2) the record has to meet the analyzable condition, which is just "Yes"
so in the cell formula bar, I would use this:
But to translate it into VBA, I'm stuck.
Has anybody has any idea?
Thanks
Bookmarks