Overview Chat Bike Members News Women
Viewing 8 posts - 1 through 8 (of 8 total)
  • Excel Help Please….
  • spacecadett
    Free Member

    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 14 years ago
    matthewjb
    Free Member

    MIN(C1,D1,E1)

    Posted 14 years ago
    StuMcGroo
    Free Member

    =MIN(C1,D1,E1)

    Posted 14 years ago
    spacecadett
    Free Member

    Splendid – thank you!

    Posted 14 years ago
    spacecadett
    Free Member

    Another quick question – is there a way I can get the formuna to ignore zero values?

    Posted 14 years ago
    tragically1969
    Free Member

    =MIN(IF(A1:A4>0,A1:A4))

    Posted 14 years ago
    ebygomm
    Free Member

    You need to Ctrl Shift and Enter with tragically1969's formula as it's an array formula

    Posted 14 years ago
    spacecadett
    Free Member

    Brilliant! Many thanks again, I have a lot to learn!

    Posted 14 years ago
Viewing 8 posts - 1 through 8 (of 8 total)

The topic ‘Excel Help Please….’ is closed to new replies.

Overview Chat Bike Members News Women