I didn't explain correct what i want. I need to deleting all rows with
duplicate minute (secundes could not be taken into account).

"JMay" пишет:

Assuming you have a single header row and you data begins on Row2;
Create a Helper column (Say Col 3) call it FindDups
in Cell C3 enter:

=IF(MID(A3,15,2)=MID(A2,15,2),TRUE,FALSE)

Copy down as far as it needed.

Type into cell C2 False

Do an Auto-filter on Column C - selecting True
Delete all resulting rows,
then Unfilter

HTH



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