EDIT: original post asked about adding values. Correct question regards multiplication.
Hello everyone
Here's a bit of VBA I found online to calculate a weighted median.
The code works nicely, except in cases where the cells in WeightRange are between 0 and 1. So it works fine if the cells in WeightRange are 1.0 and above, but the function returns a Value error if they WeightRange has anything like 0.6, 0.3, etc.![]()
Please Login or Register to view this content.
Is there any way of multiplying 100 for each cell in WeightRange while the function runs? I have tried dropping in
but it doesn't seem to do the trick (then again, I don't know VBA). Seems like something that ought to be simple enough.![]()
Please Login or Register to view this content.
Unfortunately, adding a helper column is not an option, as I have hundreds of these weight ranges....
Thanks in advance!
Bookmarks