Counting unique values and status as of last processing time

[mattyblueice]

Hello, I have a order processing spreadsheet that lists the results of the system trying to fulfill orders. If the order is processed successfully the order status is "Successful", if it failed then its "Failed" and then it will retry two more time to process the order before it will be "Abandoned". The issue is that the system is not always flagging failed orders as abandoned and essentially is in limbo. There are processing times that go along with the system fulfillments

What I need to do is count the number of unique values (order numbers) and what their status was on the last time the system tried to process that order. So I want a count of orders whose last status was "Successful" and another cell for 'Failed" (which will capture orders in limbo) and "Abandoned". I am trying a combination of Sum Product, Countifs and Max but i can't figure out how to put it all together. Any suggestions please?

Thanks

Matt

 

[Toadstool]

If you add a COUNTIF column for matching Order Nos but only anchor the last row it will countdown the matches.

Now add a column which gets the last status for each order.

Now you can count the Failed/Successful/Abandoned

Book1
	A	B	C	D	E	F	G	H
1	Order Number	Status	COUNTIF	Last Status		Failed	Succesful	Abandoned
2	X00154	Failed	6			1	3	1
3	X00154	Failed	5
4	X00154	Failed	4
5	X00154	Failed	3
6	X00154	Failed	2
7	X00154	Succesful	1	Succesful
8	X00616	Succesful	1	Succesful
9	X00693	Failed	3
10	X00693	Failed	2
11	X00693	Failed	1	Failed
12	X00924	Failed	3
13	X00924	Failed	2
14	X00924	Abandoned	1	Abandoned
15	X01232	Failed	2
16	X01232	Succesful	1	Succesful
MattyBlueIce

Cell Formulas
Range	Formula
C2:C16	C2	=COUNTIF(A2:$A$16,A2)
D2:D16	D2	=IF(C2=1,B2,"")
F2:H2	F2	=COUNTIF($D$2:$D$16,F$1)

 

[mattyblueice]

OMG- that's an easy solution (I had to wrap my head around it), but it worked beautifully. Thanks very much!