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


  • You cannot start a new topic
  • Please log in to reply
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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users