1. Guest,
    If you need help getting to know Xenforo, please see our guide here. If you have feedback or questions, please post those here.
    Dismiss Notice

Excel help - Tab name on a cell according to the lowest price

Discussion in 'Computers' started by leli, Sep 28, 2009.

  1. leli

    leli Auditioning

    Joined:
    Sep 28, 2009
    Messages:
    1
    Likes Received:
    0
    Hello there

    I have a worksheet where I am summarising all the prices received by the suppliers. What I want to do is to go through the individuals worksheets and find the lowest price (=Min) and then bring that lowest price to a cell whcih I have done, but then I need to write a the column next to that lowest price the name of the supplier (or worksheet) where that price was located....

    How can I do that?


    Thanks for your help, much appreciated
     

Share This Page