Determing latest revision in a list, with certain criteria

[D_erek]

Hi there,

i am trying to use formulae to achieve the results below.

Anyone have any suggestions as to how I would go about achieving the Output from the Input data?

I have tried using If statements and it works... except for the duplicates and the fact that there are about 40000 lines items in my sheet....
Thanks everyone for your help!

Input
A	B	D	E	F	G
Document No	Rev No	Date Sent	Package	Doct Status	Purpose
50GG	01	2013/01/01	C000	DB	DB
40GG	01	2013/01/01	P000	DB	FI
50GG	03	2013/01/05	C000	AB	FI
41GG	01	2013/01/01	P001	DI	DB
50GG	02	2013/01/10	C000	DI	DB
Output
For Package : C000
A	B	C	B	D
Document No	Latest Revision Purpose DB	Date Sent Latest Revision Purpose DB	Latest Revision Doct Status AB	Date Sent Latest Revision Doct Status
50GG	02	2013/01/10	03	2013/01/15

<tbody>
</tbody>

 

[D_erek]

[TABLE="class: cms_table"]
<tbody>[TR]
[TD]Input[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]Document No[/TD]
[TD]Rev No[/TD]
[TD]Date Sent[/TD]
[TD]Package[/TD]
[TD]Doct Status[/TD]
[TD]Purpose[/TD]
[/TR]
[TR]
[TD]50GG[/TD]
[TD]01[/TD]
[TD]2013/01/01[/TD]
[TD]C000[/TD]
[TD]DB[/TD]
[TD]DB[/TD]
[/TR]
[TR]
[TD]40GG[/TD]
[TD]01[/TD]
[TD]2013/01/01[/TD]
[TD]P000[/TD]
[TD]DB[/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]50GG[/TD]
[TD]03[/TD]
[TD]2013/01/15[/TD]
[TD]C000[/TD]
[TD]AB[/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]41GG[/TD]
[TD]01[/TD]
[TD]2013/01/01[/TD]
[TD]P001[/TD]
[TD]DI[/TD]
[TD]DB[/TD]
[/TR]
[TR]
[TD]50GG[/TD]
[TD]02[/TD]
[TD]2013/01/10[/TD]
[TD]C000[/TD]
[TD]DI[/TD]
[TD]DB[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Output[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]For Package : C000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]E[/TD]
[TD]D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Document No[/TD]
[TD]Latest Revision Purpose DB[/TD]
[TD]Date Sent Latest Revision Purpose DB[/TD]
[TD]Latest Revision Doct Status AB[/TD]
[TD]Date Sent Latest Revision Doct Status[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]50GG[/TD]
[TD]02[/TD]
[TD]2013/01/10[/TD]
[TD]03[/TD]
[TD]2013/01/15[/TD]
[/TR]
</tbody>[/TABLE]


I made a couple mistakes in my first post. See the Red font for corrections.

thanks!