MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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?
MIN(C1,D1,E1)
=MIN(C1,D1,E1)
Splendid - thank you!
Another quick question - is there a way I can get the formuna to ignore zero values?
=MIN(IF(A1:A4>0,A1:A4))
You need to Ctrl Shift and Enter with tragically1969's formula as it's an array formula
Brilliant! Many thanks again, I have a lot to learn!