Date and Time maximum data

[Anonymous]

Hi all,

Data:   

Prod, Sales,Date

    A, 10, 10 Jan 15 4pm

    A, 10, 10 Jan 15 9pm

    B, 10, 10 Jan 15 8pm

    B, 10, 10 Jan 15 11pm

    C, 10, 10 Jan 15 9pm

    A, 10, 15 Jan 15 1pm

    A, 10, 15 Jan 15 3pm

    A, 10, 15 Jan 15 6pm

    B, 10, 15 Jan 15 9pm

    C, 10, 15 Jan 15 3pm

    C, 10, 15 Jan 15 9pm

    C, 10, 15 Jan 15 7pm

    A, 10, 21 Feb 15 7pm

    B, 10, 21 Feb 15 4pm

    B, 10, 21 Feb 15 6pm

    C, 10, 21 Feb 15 11am

    C, 10, 21 Feb 15 4pm

    C, 10, 21 Feb 15 9pm

    ,

];

Please show the output ,

specific product and specific date wise ,max order date

Output :

A : 10 JAN 15 9pm

A : 15 JAN 15 3pm

A : 21 Feb  15 2pm

B : 10 Jan  15 11pm

B : 15 Jan  15 9pm

B : 21 Feb 15 6pm

C :10 Jan 15 9pm

C : 15 Jan 15 9pm

C : 21 Feb 15 9pm

Thanks

[Anonymous]

Ex:

1 jan 9pm

1 jan 5pm

max sales time is : 1 jan 9pm

That i expect

[MK_QSL]

Where is 1st Jan in your sample data...??????

[Peter_Cammaert]

Can you tell us where exactly Manish' solution goes wrong? As far as I can see, it works perfectly. Given the source data, the latest time per Prod per day is listed in each and every case.

[MK_QSL]

aniket_2701‌what's wrong with my answer?

I had given the same one !!