Deleting duplicate row
 

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.

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.

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.

Deleting duplicate row
 

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.

Deleting duplicate row
 

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.

Deleting duplicate row
 

My recommendation does what you said you wanted to do.
After dong what I said your data should look as follows:

Header1 Header2 Research
2001.01.01 00:00:02 aaa FALSE
2001.01.01 00:01:05 fgdfgfg FALSE


"RN" wrote:

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.

Deleting duplicate row
 

Thanks, JMay!
I try Your formula, but it didn't work correctly, and I try my own formula:

=IF(TIME(0;MINUTE(A3);0)=TIME(0;MINUTE(A2);0);FALS E;TRUE)

It works as I want.
Thank You for tenderness

Deleting duplicate row
 

I guess that JMay was assuming that your data were text strings, whereas
your formula is looking at a number formatted as date and time in that
particular format.

In either case the formula can presumably be simplified, as you don't need
an IF to give a TRUE/FALSE boolean result.
Try changing
=IF(TIME(0;MINUTE(A3);0)=TIME(0;MINUTE(A2);0);FALS E;TRUE) to
=TIME(0;MINUTE(A3);0)=TIME(0;MINUTE(A2);0)

or in his text formula, changing
=IF(MID(A3,15,2)=MID(A2,15,2),TRUE,FALSE) to
=MID(A3,15,2)=MID(A2,15,2)

In each case you seem to have decided merely to look at the minutes, and
you'd flag a duplicate even if you had different hours or different days?
--
David Biddulph

"RN" wrote in message
...
Thanks, JMay!
I try Your formula, but it didn't work correctly, and I try my own
formula:

=IF(TIME(0;MINUTE(A3);0)=TIME(0;MINUTE(A2);0);FALS E;TRUE)

It works as I want.
Thank You for tenderness