date date and max code

[Atul Kadam]

date date and max code we wont in Ans.
we want to result in BOLD

A date	Code	B date	Code	C date	Code	MAX date	MAX Code	MAX Cod & As per MAX date
30-Nov-16	441	20-Nov-16	5441	30-Nov-16	5441	MAX date	MAX Code	MAX Cod & As per MAX date
10-Nov-16	5441	10-Nov-16	441	30-Nov-16	211
30-Nov-16	54	30-Sep-16	5441	30-Sep-16	441
30-Jan-16	211	30-Nov-16	211	30-Jan-16	5441
1-Nov-16	211	30-Nov-16	54	1-Nov-16	211
1-Jan-16	41	1-Jan-16	41	30-Nov-16	41

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col></colgroup>

 

[Matt Rogers]

Hi, I'm not sure ...:

Formula max date in G2:            =MAX(A2,C2,E2)
Formula max code in H2:            =MAX(B2,D2,F2)
Formula max code & max date in I2: =H2&TEXT(G2," DD-MMM-YY")

 

[Atul Kadam]

My data count is High,

so we wont to VBA coding