View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brett Brett is offline
external usenet poster
 
Posts: 113
Default Help Please!! Sorting a large document using date and time

The document has 1000's of line items and each document has numerous entry's
all I need is the last entry for each document. There is an example below I
would only need the first line in this entry because it was completed at
9:44AM. I would like to sort all the documents having the ones I need all at
the top of the document and the rest I would just delete.

Thanks


N0969709WR00634 2009 MAUREEN 10/9/08 8:57 AM 10/9/08 9:44 AM N0969709WR00634
2009 MAUREEN 10/9/08 8:57 AM 10/9/08 9:04 AM N0969709WR00634 2009 MAUREEN
10/9/08 8:57 AM 10/9/08 9:04 AM