+ Reply to Thread
Results 1 to 10 of 10

Select max run id for each day

  1. 08-27-2014, 10:22 AM #1
    christopherL
    christopherL is offline
    Registered User
    Join Date
    10-11-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2002
    Posts
    71

    Select max run id for each day

    New FX TSY (TEST).xlsm


    I have several RUNIDS for several days..

    How do I setup a formula picking the max RUNID for a given date?

    Assume this
    I have 

    Please Login or Register  to view this content.
    How do I do this in a cell? selecting max(runid) where date = another cell?
    Last edited by christopherL; 08-28-2014 at 06:55 AM.
    Reply With QuoteRegister To Reply
  2. 08-27-2014, 10:37 AM #2
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Select max run id for each day

    With your sample data in A1:B6
    and
    D1: a ref date....08/26/2014

    This regular formula returns the max RUNID for that data
    Please Login or Register  to view this content.
    In that example, the formula returns: 18


    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  3. 08-27-2014, 10:47 AM #3
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Select max run id for each day

    Assuming your date in D2, try with the below array formula


    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    ☚ Click ★ just below left if it helps, Boo?ath?
    Reply With QuoteRegister To Reply
  4. 08-27-2014, 11:07 AM #4
    vshukla
    vshukla is offline
    Registered User
    Join Date
    03-01-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Select max run id for each day

    Try this ...Use this formula with ctrl+shift+enter

    =MAX(($A$2:$A$6=E2)*($B$2:$B$6))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 08-28-2014, 02:09 AM #5
    christopherL
    christopherL is offline
    Registered User
    Join Date
    10-11-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2002
    Posts
    71

    Re: Select max run id for each day

    Thanks all this worked perfectly
    Reply With QuoteRegister To Reply
  6. 08-28-2014, 02:46 AM #6
    christopherL
    christopherL is offline
    Registered User
    Join Date
    10-11-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2002
    Posts
    71

    Re: Select max run id for each day

    Quote Originally Posted by Ron Coderre View Post
    With your sample data in A1:B6
    and
    D1: a ref date....08/26/2014

    This regular formula returns the max RUNID for that data
    Please Login or Register  to view this content.
    In that example, the formula returns: 18


    Is that something you can work with?
    Hmm,
    I tried this but I get #VALUE

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 08-28-2014, 06:43 AM #7
    christopherL
    christopherL is offline
    Registered User
    Join Date
    10-11-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2002
    Posts
    71

    Re: Select max run id for each day

    bump bump bump bump
    Reply With QuoteRegister To Reply
  8. 08-28-2014, 06:47 AM #8
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Select max run id for each day

    hi ,

    It is advisable to upload sample Without any confidential data,because the solution received should work fine .

    Punnam
    Reply With QuoteRegister To Reply
  9. 08-28-2014, 06:56 AM #9
    christopherL
    christopherL is offline
    Registered User
    Join Date
    10-11-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2002
    Posts
    71

    Re: Select max run id for each day

    Quote Originally Posted by Punnam View Post
    hi ,

    It is advisable to upload sample Without any confidential data,because the solution received should work fine .

    Punnam
    Attached the file, as you can see I sheet "VaR Calcs" cell "K3" I am trying to fetch the largest RUNID in sheet Delta1 Raw, with the Date and Compare date in cell N3 and N4 in sheet VaR Calcs..

    Doesn't work for me :S
    Reply With QuoteRegister To Reply
  10. 08-28-2014, 07:26 AM #10
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Select max run id for each day

    Hi,

    Find the Updated file as requested .

    Punnam
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 08-28-2014, 07:53 AM #11
    christopherL
    christopherL is offline
    Registered User
    Join Date
    10-11-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2002
    Posts
    71

    Re: Select max run id for each day

    Quote Originally Posted by Punnam View Post
    Hi,

    Find the Updated file as requested .

    Punnam
    Hi thank you so much! And how do I get the run_id for the compare date? :D
    Last edited by christopherL; 08-28-2014 at 07:57 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Newbie: Auto Select/un-Select an Range of Slicer Items
    By luckyali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 09:52 AM
  2. [SOLVED] Modify existing code to select file instead of select folder
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2014, 09:41 AM
  3. Look up cell, use as reference to select from a range, to then select data in a column...
    By transportplanner in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-17-2013, 05:21 AM
  4. Code to prevent user to Select COLUMNS but allow to select ROWS
    By tengrosita in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2011, 03:46 AM
  5. how do you multiple select and delete rows that the data you select are in
    By kckar in forum Excel General
    Replies: 1
    Last Post: 04-23-2007, 04:23 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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1