finding the last date for an order ID when there are muliplte dates and multiple orders.

[hgoodall]

I am trying to find out for each order which was the last date that particular order had. Also there is more than one order and each have multiple orders against them.

[TABLE="width: 228"]
<tbody>[TR]
[TD]ID
[/TD]
[TD]Sched.StartDate
[/TD]
[TD]Order
[/TD]
[/TR]
[TR]
[TD]5206
[/TD]
[TD]05/01/2010
[/TD]
[TD]11175203
[/TD]
[/TR]
[TR]
[TD]5206
[/TD]
[TD]03/01/2012
[/TD]
[TD]13627997
[/TD]
[/TR]
[TR]
[TD]5206
[/TD]
[TD]31/12/2013
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5206
[/TD]
[TD]04/12/2013
[/TD]
[TD]16244494
[/TD]
[/TR]
[TR]
[TD]5206
[/TD]
[TD]12/11/2015
[/TD]
[TD]18618596
[/TD]
[/TR]
[TR]
[TD]5206
[/TD]
[TD]29/11/2017
[/TD]
[TD]20971039
[/TD]
[/TR]
[TR]
[TD]5206
[/TD]
[TD]27/11/2019
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5224
[/TD]
[TD]25/05/2012
[/TD]
[TD]14132431
[/TD]
[/TR]
[TR]
[TD]5224
[/TD]
[TD]04/05/2014
[/TD]
[TD]16759577
[/TD]
[/TR]
[TR]
[TD]5224
[/TD]
[TD]28/04/2016
[/TD]
[TD]19102395
[/TD]
[/TR]
[TR]
[TD]5224
[/TD]
[TD]04/05/2018
[/TD]
[TD]21498020
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

This is unclear.
Your thread title: "finding the last date for an order ID"
Your description: "find out for each order which was the last date"

You have 2 columns labelled ID and Order.

So are we trying to find the last date for an order or an ID cos you've mentioned both or is it something else?

Provide some clear output results from your example data.

 

[hgoodall]

it should read the last date for an ID that an order was completed and I want to see for each ID when that last date was.
Cheers
Helen

 

[Special-K99]

Again, what indicates that an order was completed?

I'm losing interest in this. Every time you reply I have to ask you another question.

And no output results as I asked for.

Last chance and I'll be answering somebody else's problem.

 

[hgoodall]

please look at this example.
these ID's have orders completed on these dates (completed jobs have an order number). What I want to find out is for each ID what is the last date it was completed.

[TABLE="width: 412"]
<colgroup><col width="132" style="width: 99pt;"><col width="123" style="width: 92pt;"><col width="72" style="width: 54pt;"><col width="85" style="width: 64pt;"></colgroup><tbody>[TR]
[TD="class: xl65, width: 132, bgcolor: #FFFF99"][TABLE="width: 412"]
<colgroup><col width="132" style="width: 99pt;"><col width="123" style="width: 92pt;"><col width="72" style="width: 54pt;"><col width="85" style="width: 64pt;"></colgroup><tbody>[TR]
[TD="class: xl65, width: 132"]ID[/TD]
[TD="class: xl65, width: 123"]Sched.StartDate[/TD]
[TD="class: xl65, width: 72"]Order[/TD]
[TD="class: xl66, width: 85"]last date[/TD]
[/TR]
[TR]
[TD="class: xl63"]5206[/TD]
[TD="class: xl64, align: right"]05/01/2010[/TD]
[TD="class: xl63"]11175203[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl63"]5206[/TD]
[TD="class: xl64, align: right"]03/01/2012[/TD]
[TD="class: xl63"]13627997[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl63"]5206[/TD]
[TD="class: xl64, align: right"]04/12/2013[/TD]
[TD="class: xl63"]16244494[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl63"]5206[/TD]
[TD="class: xl64, align: right"]12/11/2015[/TD]
[TD="class: xl63"]18618596[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl63"]5206[/TD]
[TD="class: xl64, align: right"]29/11/2017[/TD]
[TD="class: xl63"]20971039[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl63"]5224[/TD]
[TD="class: xl64, align: right"]25/05/2012[/TD]
[TD="class: xl63"]14132431[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl63"]5224[/TD]
[TD="class: xl64, align: right"]04/05/2014[/TD]
[TD="class: xl63"]16759577[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl63"]5224[/TD]
[TD="class: xl64, align: right"]28/04/2016[/TD]
[TD="class: xl63"]19102395[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl63"]5224[/TD]
[TD="class: xl64, align: right"]04/05/2018[/TD]
[TD="class: xl63"]21498020[/TD]
[TD="class: xl66"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl65, width: 123, bgcolor: #FFFF99"][/TD]
[TD="class: xl65, width: 72, bgcolor: #FFFF99"][/TD]
[TD="class: xl66, width: 85"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

in D2
=MAX(IF((A2=A$2:A$10)*(C$2:C$10<>0),B$2:B$10))
Array formula, use Ctrl-Shift-Enter

and copy down

 

[hgoodall]

thanks