Delete repeated rows in a list

Please attach a sample excel book. Go to advance then attachment. It is diffcult to see the result in text format

Hi AB33. I've attached a sample. In this sample, I have two tables. The table "Measures" have all the information and repeated rows. I need to reduce this table to "Measure Resume". This table don't have any repeated row.

Originally Posted by AB33

Please attach a sample excel book. Go to advance then attachment. It is diffcult to see the result in text format

Hi AB33. I've attached a sample. In this sample, I have two tables. The table "Measures" have all the information and repeated rows. I need to reduce this table to "Measure Resume". This table don't have any repeated row. Can you help me please?

Here's my interpretation of your problem.
The results are slightly different from yours.

Originally Posted by AB33

I do not know in which column A are the duplicates, but have assumed column B, but can easily change it if this is not the case.
I have also attached two codes. one code output is on the same sheet and the other one on different sheet.
I have also assumed that once the dups are copied, I have deleted them from the original source. This is also can easily being changed.

Hi AB33. Thanks for your help. I have a little problem with the algorithm. I'll try to increase new rows below the existent rows in the sheet measure, but the macro only returns a table with 4 rows.
I'll explain you what I need to do. I've modified my file "measures" for a better explanation of the problem.
In the sheet called "Measures", I've painted with a different color all the repeated rows. The difference between each repeated pair is only the hour in the first column, for example: 11:59:54 and 12:00:00. But the other information (2nd column, etc.) is the same. I need only a row for each repeated pair.
But there are also some rows that aren't repeated. I didn't paint these rows. These rows haven't be deleted.
In the sheet called "Resume", I've put the table that I need.

I'd be very grateful with you if you can explain me how to solve this problem

Thank you very much

Originally Posted by jindon

Here's my interpretation of your problem.
The results are slightly different from yours.

Hi jindon. Thank you for your help. II'll try to increase new rows below the existent rows in the sheet "Measure", but the macro only returns a table with 4 rows. Many rows are superimpose between them.
I'll explain you what I have to do. I've modified my file "measures" for a better explanation of the problem.
In the sheet called "Measures", I've painted with a different color all the repeated rows. The difference between each repeated pair is only the hour writed in the first column, for example: 11:59:54 and 12:00:00. But the other information is the same. I need only a row for each repeated pair.
But there are also some rows that aren't repeated. I didn't paint these rows. These rows haven't be deleted.
In the sheet called "Resume", I've put the table that I need to obtain.

Thanks for your time and for your help.

Sorry that I ask very things, but I only know very little of Excel macros.

measures.xlsx

My understanding of "Duplicates" in this case was from co.B to col.G.

So, I don't think I understand your problem.

Originally Posted by jindon

My understanding of "Duplicates" in this case was from co.B to col.G.

So, I don't think I understand your problem.

Thanks jindon. Don't worry. I've resolved that using your and ABB3 macros. But I still have a question to solve.

I need to obtain the dates in the first column, for example "1-JAN-2013 00:45:00.017", but in the sheet I see some as "41275.03125". I'll try to change the format in Excel a "dd-mmm-yyyy hh:mm:ss.sss", but the result is "1-ene-2013 00:45:00.00". I need to see "1-JAN-2013 00:45:00.017". Can you help me please?

I don't know if this problem is due to the language.

Thanks