NeedyHelpExcelMan
New Member
- Joined
- Jun 25, 2014
- Messages
- 17
Hello All:
I am writing code in XL2010 and I have a question RE Median Functions in VBA. I have a column of data in column B and F. I want to produce a value in column G (calculated using data from Column F) given a criteria in column B. Below is an example of the data.
I'd like a function that would be able to recognize for all "100"s in column B, pull the correspond data in column F and find the median of it. Then take the value in column F and subtract the median of the corresponding median. For example cell G2 would be equal to: =F2-MEDIAN(F2:F5); G3 would be: =F3-MEDIAN(F2:F5) and so on and so forth. If this needs further explanation, please comment and let me know. Thanks in advance
<TBODY>
</TBODY>
I am writing code in XL2010 and I have a question RE Median Functions in VBA. I have a column of data in column B and F. I want to produce a value in column G (calculated using data from Column F) given a criteria in column B. Below is an example of the data.
I'd like a function that would be able to recognize for all "100"s in column B, pull the correspond data in column F and find the median of it. Then take the value in column F and subtract the median of the corresponding median. For example cell G2 would be equal to: =F2-MEDIAN(F2:F5); G3 would be: =F3-MEDIAN(F2:F5) and so on and so forth. If this needs further explanation, please comment and let me know. Thanks in advance
B | F | G |
100 | 10000 | |
100 | 10000 | |
100 | 12000 | |
100 | 15000 | |
101 | 50000 |
<TBODY>
</TBODY>