Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2007
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post

    Hello,

    I'm creating a sheet to process where a document is in a workflow system. Please see the attachment. I highlighted cell "AN4". What I'm tryin to do is add a logic formula that will pull the most current status in to that cell based off the date entered by the user in the columns to the left.

    You will see in the sample a shipment "DO1PPC0002". The last update made was 6/8/09 and it was "Entered 4a". How do I get that last action to also show up in cell AN4, as well as any future status changes? This would help me have the current status for all future shipments in the same column, which I could then filter and/or create a pivot table from.

    Thanks

    sulli101
    Attached Files Attached Files

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

    =INDEX($A4:$AM4,MATCH(MAX(D4,H4,J4,N4,Q4,S4,W4,Y4, AA4,AC4,AG4,AI4,AK4,AM4),$A4:$AM4,0)-1)

    It can be filled down (but it will return #N/A if there are no data yet)

  3. #3
    New Lounger
    Join Date
    Jan 2007
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Awesome, thanks! I also see if I remove the "-1" from the formula, it gives me the date entered. I can use this in AO4.

Posting Permissions

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