LeilaniMerle
New Member
- Joined
- Jan 26, 2014
- Messages
- 22
Hi there,
I have a spreadsheet wherein I need to extract the minimum value from 4 Suppliers. The suppliers are colour coded, and i would like the extracted amount to show the suppliers colour code as well as the value.
I am merely using currently the Min function. Can anyone assist me?
<colgroup><col><col><col span="7"><col><col></colgroup><tbody>
</tbody>
I have a spreadsheet wherein I need to extract the minimum value from 4 Suppliers. The suppliers are colour coded, and i would like the extracted amount to show the suppliers colour code as well as the value.
I am merely using currently the Min function. Can anyone assist me?
QTY | Supplier 1/Unit | Supplier 1 \Total | Supplier 2/Unit | Supplier 2 \Total | Supplier 3/Unit | Supplier 3 \Total | Supplier 4/Unit | Supplier 4 \Total | Minimum supplier | |
10A Circuit Breaker | 10 | 12.45 | 124.5 | 13.66 | 136.6 | 17.55 | 175.5 | 9.33 | 93.3 | 9.33 |
25 A Circuit Breaker | 10 | 1.20 | 12.00 | 7.60 | 76.00 | 9.00 | 90.00 | 5.00 | 50.00 | 1.20 |
Plug Top Arrestor 16A | 10 | 2.40 | 24.00 | 8.30 | 83.00 | 6.00 | 60.00 | 4.00 | 40.00 | 2.40 |
Connector Strip 16A12W Black | 10 | 6.50 | 65.00 | 9.50 | 95.00 | 8.00 | 80.00 | 7.00 | 70.00 | 6.50 |
VEC 236 ELB Fluorescent Fitting | 20 | 3.30 | 66.00 | 4.70 | 94.00 | 7.00 | 140.00 | 8.00 | 160.00 | 3.30 |
VEC 258 ELB Fluorescent Fitting | 20 | 2.30 | 46.00 | 6.20 | 124.00 | 4.00 | 80.00 | 6.00 | 120.00 | 2.30 |
CLF Genie 11W/827 B22 PHI | 150 | 1.60 | 240.00 | 1.20 | 180.00 | 2.00 | 300.00 | 2.00 | 300.00 | 1.20 |
CLF Genie 11W/827 E27 PHI | 150 | 5.50 | 825.00 | 4.00 | 600.00 | 3.00 | 450.00 | 5.00 | 750.00 | 3.00 |
H/Saw Bld 18T BI-MET NICH | 20 | 6.20 | 124.00 | 3.00 | 60.00 | 1.00 | 20.00 | 4.00 | 80.00 | 1.00 |
Hacksaw BLD JUNIOR SPEAR | 10 | 3.90 | 39.00 | 5.00 | 50.00 | 5.00 | 50.00 | 1.00 | 10.00 | 1.00 |
SAM CB SF2-G DP 60A | 10 | 7.20 | 72.00 | 7.00 | 70.00 | 6.00 | 60.00 | 3.00 | 30.00 | 3.00 |
SAM CB SF3-G3 TP 30A CBI | 15 | 4.60 | 69.00 | 8.90 | 133.50 | 9.00 | 135.00 | 8.00 | 120.00 | 4.60 |
SAM CB SF2-G3 DP 15A CBI | 15 | 1.20 | 18.00 | 8.90 | 133.50 | 8.00 | 120.00 | 9.00 | 135.00 | 1.20 |
Surfix 2,5x3 + E WHI -100m | 200 | 4.30 | 860.00 | 6.00 | 1200.00 | 4.00 | 800.00 | 6.00 | 1200.00 | 4.00 |
Ceen Ext Box 4x2 CT9052 | 20 | 5.60 | 112.00 | 3.50 | 70.00 | 5.00 | 100.00 | 5.00 | 100.00 | 3.50 |
Ceen Ext Box 4x4 CT9054 | 20 | 7.80 | 156.00 | 2.40 | 48.00 | 2.00 | 40.00 | 4.00 | 80.00 | 2.00 |
50W GU10 230V 36° Halogen | 200 | 4.10 | 820.00 | 7.60 | 1520.00 | 6.00 | 1200.00 | 2.00 | 400.00 | 2.00 |
Surfix 1.5 2+E-100m | 200 | 2.20 | 440.00 | 8.10 | 1620.00 | 3.00 | 600.00 | 1.00 | 200.00 | 1.00 |
Surfix 2.5 2+E-100m | 200 | 10.60 | 2120.00 | 5.30 | 1060.00 | 5.00 | 1000.00 | 4.00 | 800.00 | 4.00 |
Candle Lamp 240V 40W/60W | 200 | 8.40 | 1680.00 | 9.20 | 1840.00 | 7.00 | 1400.00 | 5.00 | 1000.00 | 5.00 |
Ballast Osram 2x36 EKB 2QT FIT 8 | 20 | 9.70 | 194.00 | 9.60 | 192.00 | 8.00 | 160.00 | 6.00 | 120.00 | 6.00 |
Term DISCONN FEMALE FLAT | 100 | 6.30 | 630.00 | 7.10 | 710.00 | 5.00 | 500.00 | 3.00 | 300.00 | 3.00 |
Term DISCONN MALE FLAT BLU | 100 | 5.20 | 520.00 | 4.00 | 400.00 | 6.00 | 600.00 | 2.00 | 200.00 | 2.00 |
Lamp 400W HPS SON-T E40 | 24 | 4.80 | 115.20 | 3.00 | 72.00 | 4.00 | 96.00 | 7.00 | 168.00 | 3.00 |
Wall Plug & Screw (Fischer Plugs) | 100 | 9.60 | 960.00 | 5.20 | 520.00 | 2.00 | 200.00 | 8.00 | 800.00 | 2.00 |
Gland 1 PVC White | 20 | 4.20 | 84.00 | 6.30 | 126.00 | 6.00 | 120.00 | 9.00 | 180.00 | 4.20 |
Gland 0 PVC White | 20 | 1.30 | 26.00 | 8.50 | 170.00 | 1.00 | 20.00 | 5.00 | 100.00 | 1.00 |
VEC 218 ELB Fluorescent Fitting | 10 | 6.30 | 63.00 | 1.40 | 14.00 | 3.00 | 30.00 | 6.00 | 60.00 | 1.40 |
G4-20W-12V Halogen 2000hr | 50 | 4.10 | 205.00 | 8.60 | 430.00 | 9.00 | 450.00 | 2.00 | 100.00 | 2.00 |
Stove Plate Solid 8" | 40 | 9.50 | 380.00 | 8.70 | 348.00 | 6.00 | 240.00 | 5.00 | 200.00 | 5.00 |
Stove Solid 6" Solid 6" | 40 | 8.30 | 332.00 | 1.30 | 52.00 | 5.00 | 200.00 | 2.00 | 80.00 | 1.30 |
Lamp 240V 11W ES Mini | 100 | 9.60 | 960.00 | 4.50 | 450.00 | 2.00 | 200.00 | 4.00 | 400.00 | 2.00 |
3kw Element & Thermostat KEG3A | 15 | 2.80 | 42.00 | 6.20 | 93.00 | 1.00 | 15.00 | 3.00 | 45.00 | 1.00 |
3Kw Geyser Spiral & Thermostat | 10 | 1.30 | 13.00 | 1.20 | 12.00 | 4.00 | 40.00 | 6.00 | 60.00 | 1.20 |
CRC 2005 2.26 Multipurpose | 5 | 7.50 | 37.50 | 1.30 | 6.50 | 6.00 | 30.00 | 1.00 | 5.00 | 1.00 |
Self Tapping Screw PAN HD | 100 | 8.60 | 860.00 | 1.40 | 140.00 | 8.00 | 800.00 | 8.00 | 800.00 | 1.40 |
Self Tapping Screw PAN HD | 100 | 5.80 | 580.00 | 5.60 | 560.00 | 9.00 | 900.00 | 7.00 | 700.00 | 5.60 |
Self Tap Screw 8x40mm | 100 | 6.90 | 690.00 | 8.90 | 890.00 | 7.00 | 700.00 | 9.00 | 900.00 | 6.90 |
Fluor Tube 32 W Circline Eurolux | 20 | 4.20 | 84.00 | 7.50 | 150.00 | 5.00 | 100.00 | 4.00 | 80.00 | 4.00 |
Fluor Tube 40W Circline Eurolux | 20 | 2.20 | 44.00 | 7.40 | 148.00 | 3.00 | 60.00 | 2.00 | 40.00 | 2.00 |
SUB TOTAL EX VAT | 219.55 | 14732.20 | 237.76 | 14677.10 | 217.55 | 12361.50 | 197.33 | 11076.30 | ||
14% VAT | 30.74 | 2062.51 | 33.29 | 2054.79 | 30.46 | 1730.61 | 27.63 | 1550.68 | ||
TOTAL | 250.29 | 16794.71 | 271.05 | 16731.89 | 248.01 | 14092.11 | 224.96 | 12626.98 | |
<colgroup><col><col><col span="7"><col><col></colgroup><tbody>
</tbody>