M
M Moore
I have three columns of data
Column A Column B Column C
247,156 247,156 .40
0 247,156 .40
0 247,156 .40
245,156 494,312 .70
247,156 741,468 .30
Column B is a running total of column A.
I need to extract the value from column C based on where a value falls
within the ranges identified in column B.
For example, if the criteria value is 500,000, I would want to extract .70.
If the criteria value is 230,000, I would want to extract .40. If the
criteria value is 750,000, I would want to extract .30.
Is the following formula the best way to get this data:
Hlookup(large(b1:b5,countif(b1:b5,">"&d1)+1),b1:c5,2,false)
Will I have a problem with this formula since column B has 3 values that are
equal?
Thanks
Column A Column B Column C
247,156 247,156 .40
0 247,156 .40
0 247,156 .40
245,156 494,312 .70
247,156 741,468 .30
Column B is a running total of column A.
I need to extract the value from column C based on where a value falls
within the ranges identified in column B.
For example, if the criteria value is 500,000, I would want to extract .70.
If the criteria value is 230,000, I would want to extract .40. If the
criteria value is 750,000, I would want to extract .30.
Is the following formula the best way to get this data:
Hlookup(large(b1:b5,countif(b1:b5,">"&d1)+1),b1:c5,2,false)
Will I have a problem with this formula since column B has 3 values that are
equal?
Thanks