Macro for deleting certain rows

[drmix]

Hi,

I have a data set which show the time and date (down the page) of all the trades in a particular stock.

I would like to create a macro which will delete all the trades which are not the last trades for the day. The catch is that there may be more than one last trade for the day because they have the same timestamp.

The date is in column B (dd/mm/yyyy)
The time is in column C (24 hours hh:mm:ss)

Thank you in advance