Finding the best price

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a range of suppliers who supply the same products. The spreadsheet lists the suppliers products and each suppliers prices. I need to see for each product who has the best price. Anyone have any ideas how to do this

Thyssens HYDRO Servive Klockner Simmal



TUBE 3/8 OD X 16 G 6063'A'T6 5030 0.113 2.06 £0.23 £0.22 £0.21 £0.22
TUBE 1/2 OD X 16 G 6063'A'T6 5030 0.155 2.06 £0.32 £0.30 £0.29 £0.30 £0.28
TUBE 5/8 OD X 16 G 6063'A'T6 5030 0.21 2.06 £0.43 £0.40 £0.39 £0.40
 
One way to show the lowest is to use conditional formatting.

If your suppliers are in columns B,C,D,E,F etc and start at row 2 then
using Conditional Format for cell B2 enter the following:

"Cell value is", "Equal to" =MIN($B2:$F2) press the format button
and choose a colour to highlight the cell.

Paste the format to cells C2 to F2 and then to the rest of the columns
B:F

Note: If a cell is blank it will be omitted from the formula, but if it
contains a zero it will be shown as the lowest rate.

Hope this is what you are looking for

Mike
 
Back
Top