Mark the Lowest price in a price-matrix

hi all,

i have this table of destinations and prices offered from different carriers for those destinations, what i need is find out the lowest three prices for each destination, the table looks like below:

---A-----------B------------C---------D-------E----------F
1--Country-Country Code--A price----B Price--C Price---D Price
2 --UK-----------445------2.8--------3.1-------1.9------3.0
3--USA----------112------3.0--------4.0---------5------5.5
4-INDIA----------919----- 2.1--------3.2-------3.4-------3.1

so the resulted table should highlight the lowest 3 prices for each destination, taking in consideration that my table contains 9 different prices from 9 different companies for each destination with more than 25,000 records, note that if you have any alternative method to retrieve the lowest values, feel free to use it as my purpose is just to know which operators offer the lowest prices

please find attached a sample of the table, and many thanks in advance

I think it would be very hard because you don't have separated countries. For example, you have ALBANIA TIRANE and Albania,Tirana.

Probably it would be easier if you would have all this in two columns... Countr + rest

A	B	C
Afghanistan - Mobile Roshan	Afghanistan	Mobile Roshan

Select C2:K54 and invoke Conditional Formatting from the Home tab

Select New Rule

Select Use a Formula to determine which cells to format

Enter formula: =AND(C2<=SMALL($C2:$K2,3),C2<>"")]

Click Format to choose your highlighting preferences.

Click Ok

Click Ok to finish.

See attached...

3 separate conditional formats are now applied

=AND(C2=SMALL($C2:$K2,1),C2<>"")

=AND(C2=SMALL($C2:$K2,2),C2<>"")

=AND(C2=SMALL($C2:$K2,3),C2<>"")

It's working.. i thought that i.e. Algeria - Mobile Orascom is one destination... WD NBVC if this is only he need

You're welcome..

Can you please mark your thread as Solved?

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save