-

Jump to content



Photo
- - - - -

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


This topic has been archived. This means that you cannot reply to this topic.
No replies to this topic

#1 of 1 leli

leli

    Auditioning

  • 1 posts
  • Join Date: Sep 28 2009

Posted September 28 2009 - 05:12 PM

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