+ Reply to Thread
Results 1 to 3 of 3

Compare values in cells and find the lowest value + formatting the original data

  1. #1
    Registered User
    Join Date
    06-15-2013
    Location
    Europe
    MS-Off Ver
    Excel 2003
    Posts
    7

    Compare values in cells and find the lowest value + formatting the original data

    Hi, I have a sheet with prices of different products from different companies. I would like to find out which price is the lowest and write it to the next column with the name of the company who has the lowest price for that particular product (row). Additionally it would be great to have visual formatting of the lowest price in the original data.

    Below you can find a sample document with original data and with "simulated result" below.
    sample-worksheet.xlsx

    Any help would be appreciated. Thanks!

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Compare values in cells and find the lowest value + formatting the original data

    In E11 (for the lowest price)
    =MIN(B11:D11)

    In F11 (for the company name that had the lowest price)
    =INDEX(B$10:D$10,MATCH(E11,B11:D11,0))


    As far as getting the format...that's a whole other ballgame.
    Can't really do it with a formula, it would likely require VBA.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Compare values in cells and find the lowest value + formatting the original data

    in E11 put
    =MIN(B11:D11)
    and copy down
    Now in F11
    =INDEX($B$10:$D$10,MATCH(E11,B11:D11,0))
    and copy down

    then conditional format
    use
    =B11=MIN($B11:$D11)

    for the original cond frmt use
    =B2=MIN($B2:$D2)
    Attached Files Attached Files
    Last edited by etaf; 07-03-2013 at 05:27 PM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1