R
Ruth
Hi
We have a data base that has columns such as start point, load point and
unload point with the distance between each in a separate column. We want to
create a column that will look up the load point and unload point and give us
the distance. The problem is that the load point and unload point are often
times listed up to 5 times, as the start point is different, so the formula
we are using
SUMPRODUCT(table range=cell)*(table range=cell)*(table)
is summing the distances.
What is a formula we can use that will not add the distance together?
We have a data base that has columns such as start point, load point and
unload point with the distance between each in a separate column. We want to
create a column that will look up the load point and unload point and give us
the distance. The problem is that the load point and unload point are often
times listed up to 5 times, as the start point is different, so the formula
we are using
SUMPRODUCT(table range=cell)*(table range=cell)*(table)
is summing the distances.
What is a formula we can use that will not add the distance together?