Delete second duplicate rows

[Panoos64]

Hi all, i would like to write a vba so that to delete the second duplicate entire rows as my below extracts. In sch. 2. are the original data and on sch. 2. is the expected result.

Thanking you in advance





Sch.1.

	A	C	D
1	31-12-17	January	February
2	7800005 ΙNDIVIDUALS	7,800	6,500
3	7800022-BUISINESS
4	7800022-BUISINESS
5	7800027-TOUR OPERATORS	3,282	2,155
6	7800027-TOUR OPERATORS
7	7800035-CONFERENCES	5,478	4,578
8	7800035-CONFERENCES
9	7800068-FUNCTIONS		1,258
10	7800068-FUNCTIONS

<colgroup><col style="mso-width-source:userset;mso-width-alt:804;width:17pt" width="22"> <col style="mso-width-source:userset;mso-width-alt:5778;width:119pt" width="158"> <col style="mso-width-source:userset;mso-width-alt:2084; width:43pt" width="57" span="2"> </colgroup><tbody>
</tbody>

Sch.2.

	A	C	D
1	31-12-17	January	February
2	7800005 ΙNDIVIDUALS	7,800	6,500
3	7800022-BUISINESS
4	7800027-TOUR OPERATORS	3,282	2,155
5	7800035-CONFERENCES	5,478	4,578
6	7800068-FUNCTIONS		1,258

<colgroup><col style="mso-width-source:userset;mso-width-alt:804;width:17pt" width="22"> <col style="mso-width-source:userset;mso-width-alt:5778;width:119pt" width="158"> <col style="mso-width-source:userset;mso-width-alt:2084; width:43pt" width="57" span="2"> </colgroup><tbody>
</tbody>

 

[Marcelo Branco]

Considering the example converting the range into a table, it is Excel that does this automatically - it's a built-in feature.
Someone at Microsoft created the code that keeps only the first instance up.
We, users, do not have to do anything, just follow the steps.

M.

 

[Panoos64]

Thanks for inform me this trick Marcelo! It was an important for me and that why i was asking!

 

[Panoos64]

Well done oldb!! 72 years and you improve your knowledge!! well done once again and all the best to you!!