Jump to content



Sign up for a free account to remove the pop-up ads

Signing up for an account is fast and free. As a member you can join in the conversation, enter contests and remove the pop-up ads that guests get. Click here to create your free account.

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 OFFLINE   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