Results 1 to 10 of 15

Thread: Find The Lowest Corresponding Value For A Repeated Value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-03-2013, 02:32 PM #7
    rovaniemi
    rovaniemi is offline
    Junior Member
    Join Date
    Jul 2013
    Posts
    11
    Rep Power
    0
    Rick thanks again. Using the above formula gives 0 as result.I don't know If I have been explaining things correctly. When I said minimum value what I meant is not zero.

    We don't need zero here. The minimum value for 212 is 3. Likewise the minimum value for 223, 230, 242 should be 1, 3, 5 respectively. That is the formula I am looking for.

    Thank you so much for the reply and patience.

    I have attached image and excel file of how the answer should be.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by rovaniemi; 07-03-2013 at 02:51 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Find Missing Values By Comparing Two Columns / Find Missing Data In Column
    By Howardc in forum Excel Help
    Replies: 4
    Last Post: 04-05-2013, 12:08 PM
  2. Sequential Lowest Value From Same Column For Each Element
    By RobExcel in forum Excel Help
    Replies: 1
    Last Post: 03-19-2013, 03:35 PM

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
  •  

Forum Rules