| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple arrays in Median function -- VBA
I am trying to implement a function that I built using Excel in VBA. My function is: {=MEDIAN(IF((A1:A100)*(A1:A10<5),B1:B10)} This function tells me: calculate the median for the values in the range B1:B10 for which the corresponding values in A1:A10 are greater than 0 and less than 5.
How can I enable the same functionality in VBA? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Median If Function | Excel Worksheet Functions | |||
| Median Function | Excel Discussion (Misc queries) | |||
| median function | Excel Worksheet Functions | |||
| median function | Excel Worksheet Functions | |||
| Median function | Excel Discussion (Misc queries) | |||
Threaded Mode
