View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Deleting duplicate row

Is column A sorted?
did you want to delete this row 2001.01.01 00:00:49? Your output skipped
this row!

"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.