Hello,
I would like to ask for help on this issue.
I have a list of items and cost and I need to find the median for every set of item
example:
<tbody>
</tbody>
I am trying to do this in excel vba
how can I write the macro to find the median for each item?
I thought of a for loop but I am stuck when it comes to how to write the range so I will be dynamic
Any help is greatly appreciated!
I would like to ask for help on this issue.
I have a list of items and cost and I need to find the median for every set of item
example:
item | Cost | Median | |
apple | 3 | apple | 3.75 |
apple | 2.8 | orange | 4.3 |
apple | 5.3 | ||
apple | 4.5 | ||
orange | 2.3 | ||
orange | 4.3 | ||
orange | 5.7 | ||
orange | 4.3 | ||
orange | 3.5 | ||
orange | 6.1 | ||
orange | 3.9 |
<tbody>
</tbody>
I am trying to do this in excel vba
how can I write the macro to find the median for each item?
I thought of a for loop but I am stuck when it comes to how to write the range so I will be dynamic
Any help is greatly appreciated!