Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Minimum of a Date (all)

    hello,

    i have a list of projectdates and my problem is to get out the minimum date of a single subphase for in this list i have single entries for each resource of our staff.
    does anyone know how to get this out (using dbmin or something else)??
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Minimum of a Date (all)

    You can place this formula in M2 and confirm with Ctrl+Shift+Enter since it is an array formula:

    =MIN(IF($C$2:$C$34=$L2,E$2:E$34))

    You can fill this down to M7, then right to column N. Format M2:N7 as dates.
    You'll get incorrect answers in M6 and N6 since there are no data for subcode 500.

    See attached version.
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Minimum of a Date (all)

    hi hans,

    thanks for your answer, the formula gives back the date for all subphases with number 100, 200, 300, &so on.
    i was not as precise as i should be, it should return the minimum value of all entries for one subphase in a project, 5111 e.g.
    that is much more difficult, as i tried to link the projectcode to the code from the subphase. if i try to, the formula gives back 0 (0.1.1900)..

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Minimum of a Date (all)

    Try this array formula. It also leaves the cell blank if there are no data for the project and subphase.
    <code>
    =IF(SUM(($A$2:$A$34=$K$2)*($C$2:$C$34=$L2))=0,"",M IN(IF(($A$2:$A$34=$K$2)*($C$2:$C$34=$L2),E$2:E$34) ))
    </code>
    See attached version.
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Minimum of a Date (all)

    merci for your support,
    stefan

Posting Permissions

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