Hello:

I have a spreadsheet that has the following columns:

Sales Document Number
Sales Customer PO Number
Item Number
Time of Day of Document Number Entry

There are other columns, actually, but these are the important ones.

I need to (a) sort this spreadsheet in order by Time of Day, Sales Document
Number, Sales Customer PO Number, and Item Number and (b) remove the records
with the more recent time of day.

The reason I want to do this is because there are a few records in this
spreadsheet with duplicate records. The only way to remove these duplicates
is to remove the records with the more recent time of day and in the column
order that I just specified.

When I say "more recent time of day", this would mean that 8AM needs to be
removed instead of 7AM.

Any ideas? I hope that it does not involve VBA programming, as I do not
know this.

Thanks!

childofthe1980s