Results 1 to 10 of 15

Thread: Find The Lowest Corresponding Value For A Repeated Value

Threaded View

rovaniemi Find The Lowest Corresponding... 07-03-2013, 11:59 AM
rollis13 Cross-post: Excelguru.ca... 07-03-2013, 01:44 PM
rovaniemi I don't understand. Did I... 07-03-2013, 02:04 PM
Rick Rothstein Give this array-entered**... 07-03-2013, 02:04 PM
rovaniemi Thank you Rick. But when I... 07-03-2013, 02:15 PM
Rick Rothstein Sorry, 41085 is the serial... 07-03-2013, 02:27 PM
rovaniemi Rick thanks again. Using the... 07-03-2013, 02:32 PM
Admin Hi Tweak Rick's formula... 07-03-2013, 03:24 PM
rovaniemi A million thanks to Admin and... 07-03-2013, 05:59 PM
Excel Fox rovaniemi, please read... 07-03-2013, 09:28 PM
Rick Rothstein And then after you read the... 07-03-2013, 09:41 PM
rovaniemi It was my mistake. I have... 07-04-2013, 10:25 AM
rovaniemi Hi everyone, I have a new... 07-05-2013, 11:57 AM
Excel Fox rovaniemi, If your... 07-05-2013, 12:40 PM
rovaniemi I am really sorry. I will... 07-05-2013, 01:00 PM
Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    11
    Rep Power
    0

    Find The Lowest Corresponding Value For A Repeated Value

    Hi everyone

    I am new to this forum and very bad in excel. I have hit a roadblock right now. I have attached an excel file.

    My issue is this:

    I want to find the lowest value associated with a each codes (212, 223, 230, 242) corresponding to its value in the C column.

    I have tried using this formula - =IF(COUNTIF($B$2:B2,B2)>1,"",MIN(IF(($B$2:$B$17=B2 )*($C$2:$C$17<>0),$C$2:$C$17)))


    When using this formula, the value associated with Column B is changing as the cell changes, but the value of Column C doesn't change accordingly, when the equation is applied in the Column D. The result remains the same for the entire D column.

    The resultant value of 212 is 3. The values for 223, 230, 242 should be 1, 3, 5 respectively. I would be very much obliged if someone can derive one formula with which I can get the required results.

    The value of the C column should change (finding the lowest value)

    Thank you all in advance for your replies and efforts.
    Attached Files Attached Files
    Last edited by rovaniemi; 07-03-2013 at 12:31 PM.

Similar Threads

  1. Replies: 4
    Last Post: 04-05-2013, 12:08 PM
  2. Replies: 1
    Last Post: 03-19-2013, 03:35 PM

Posting Permissions

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