I am working on a spreadsheet with close to 300 shipping lanes and
about 10 carriers per lane. I have succeeded in ranking each lane by
the lowest to highest freight cost; however, now I need to figure out
how to override the rank so that I can designate a preferred carrier
for a rank position (1
I have a worksheet that tracks rates for multiple lanes by multiple
carriers. I am trying to find an easy way to calculate the difference
between the rate for each carrier on a lane and the lowest rate for a
given lane. I am spending a lot of time manually correcting formulas,
and I would like
I have a worksheet that tracks rates for multiple lanes by multiple
carriers. I am trying to find an easy way to calculate the difference
between the rate for each carrier on a lane and the lowest rate for a
given lane. I am spending a lot of time manually correcting formulas,
and I would like
I have a worksheet that tracks rates for multiple lanes by multiple
carriers. I am trying to find an easy way to calculate the difference
between the rate for each carrier on a lane and the lowest rate for a
given lane. I am spending a lot of time manually correcting formulas,
and I would like to
I am trying to rank values in column D contingent on value in column A
& B. I also would like like values in column D to have the same
rank. Example data is attached below. Column E shows the order in
which I would like the sample to rank. What formula can I use?
column AB
