Current Status Cell

Topic

New Reply

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

Reply | Quote

Replies

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)

Reply | Quote

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.

Reply | Quote