Data against max date for some matching criteria

[MacPro]

Dears,

I am trying to get values of colmns Reference (Person Name) & Flag (A,B,C etc) against max date for each of three Types i.e. CREDIT,DEBIT and reversal against A/C (Which may change). Sample data is as under alongwith desired outcome perhaps it may clear my objective. and plz sorry for the formatting as i tried to draw a table but page expired)

Sample data:
A/C -----Date-------Type-----Referecne---Flag
XYZ -----28-Jan-13---CREDIT-----Smith-------AXYZ------30-Dec-13--CREDIT-----Steve-------BXYZ------1-Feb-13----DEBIT------Paul--------G
XYZ------28-Jan-13---DEBIT------Smith-------EXYZ------10-Dec-12---REVERSAL--Steve-------DXYZ------1-Jan-13-----REVERSAL--John---------J
Desired Output

-----------------CREDIT----------------------------DEBIT----------------------REVERSAL-------
A/C----Date------Reference Flag----Date-------Reference-----Flag----Date-----Reference----Flag
XYZ----30-Dec-13 Steve-------B------1-Feb-13---Paul-------------G------1-Jan-13---John----------J

what could be the best approch in excel?

 

[MacPro]

Please ignor the above sample data due to formatting, following is the sample

Sample data:
A/C -----Date-------Type-----Referecne---Flag
XYZ -----28-Jan-13---CREDIT-----Smith-------A
XYZ------30-Dec-13--CREDIT-----Steve-------B
XYZ------1-Feb-13----DEBIT------Paul--------G
XYZ------28-Jan-13---DEBIT------Smith-------E
XYZ------10-Dec-12---REVERSAL--Steve-------D
XYZ------1-Jan-13-----REVERSAL--John---------J

Desired Output

-----------------CREDIT----------------------------DEBIT----------------------REVERSAL-------
A/C----Date------Reference Flag----Date-------Reference-----Flag----Date-----Reference----Flag
XYZ----30-Dec-13 Steve-------B------1-Feb-13---Paul-------------G------1-Jan-13---John----------J