View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Deleting duplicate row

I assume you want the first incident in each minute

Is this is a date /time format or is this a text file,
equaitons will be different


"RN" wrote:

Hi, everybody.
I have the following table

A B
2001.01.01 00:00:02 aaa
2001.01.01 00:00:03 ddddd
2001.01.01 00:00:03 dfgd
2001.01.01 00:00:49 ffghfh
2001.01.01 00:01:05 fgdfgfg
2001.01.01 00:01:13 fggf
2001.01.01 00:01:55 vkljdk.

I want to delete duplicate in collumn A rows. In other words I want to see:

A B
2001.01.01 00:00:02 aaa
2001.01.01 00:01:05 fgdfgfg

Please, help me.