Over Rule - Formula Function!

[ianternet]

hi all

attached is an example SS

What I want done is:

to be able to determine which route over rules another IF a price are equal to each other.

for example, Row 2 contains numbers - basically an order in which I can change and manage of the carriers I want to overrule base on least pricing.

Row 4 is a simple example, if carrier a and b match in price I want carrier b to over rule

Row 6 is another example where the highlighted cells are the more expensive but I would like Carrier G to over rule Carrier E

Row 7 is another one where all the prices are similar and I need them to be on order based on the number sequence I have on row 2

I was using an offset function to determine least cost by carrier but will only chose the first column over another column behind it

for column J-P I would like the same instance of what I discussed above. but where LCR is where i used the offset function to determine carrier but again I would it to determine which overrules who and in relation to its pricing as well

thanks

need more explanation let me know

[ianternet]

Here is the updated one!

[ianternet]

anyone see or check on how this can be done?