(Solved) – Problem with Copy Pasting Array Formula in VBA


I am trying to put a vba formula which helps me find the median for a range of cells if these values pertain to a paricular category.

Here is the sheet sample with data:

Snip of the Data

This is the code i want to put in Cell B2 and then be able to drag it down till B7:

I have tried innumerable ways but can’t find its solution.

Thanks in advance for the help.

Leave a Reply

Your email address will not be published. Required fields are marked *