Forum menu
Topic starter
Can anybody help me identify a formula that can find the lowest value from a set of data:
If I have a product in Column A and 3 suppliers in columns C, D and E with their prices in the cells below - is there a formula I can add to column B to find the lowest value from columns C/D/E and pull that value into column B and therefore identify the cheapest rate/supplier for a given product?
Thanks for your help?
Posted : 30/04/2010 10:28 am
MIN(C1,D1,E1)
Posted : 30/04/2010 10:29 am
=MIN(C1,D1,E1)
Posted : 30/04/2010 10:33 am
Topic starter
Splendid - thank you!
Posted : 30/04/2010 10:35 am
Topic starter
Another quick question - is there a way I can get the formuna to ignore zero values?
Posted : 30/04/2010 12:30 pm
=MIN(IF(A1:A4>0,A1:A4))
Posted : 30/04/2010 12:32 pm
You need to Ctrl Shift and Enter with tragically1969's formula as it's an array formula
Posted : 30/04/2010 12:37 pm
Topic starter
Brilliant! Many thanks again, I have a lot to learn!
Posted : 30/04/2010 12:54 pm