remove duplicate rows from 2 tables on the same tab

StuartKStout

New Member
Joined
Mar 28, 2017
Messages
10
Hi All

I have an excel document with multiple tabs, the first tab pulls 2 tables from a URL. what I need to do is remove the duplicates from the second table where they appear in the top 24 rows of the first table.

the first table is at B18:J78 -(the data changes so the below is an example) the second table is has the same header row but different slightly data but some duplicates on the same at TAB L18:T78.

what I need is to remove any duplicates from the table L18:T78

Regards
Stuart

RankNameRanked Club YoB Meet NameVenueLevelDateTime
1Jacob PetersPoole0Commonwealth Games 2018Brisbane, Australia106/04/201824
2Lewis FraserSwansea Aq0Swim Wales LC ChampionshipsSwansea102/04/201824.68
3Daniel SavageNorthampton0Edinburgh International Inc British ChampionshipsEdinburgh102/03/201824.73
4Lewis BurrasSouthport0Edinburgh International Inc British ChampionshipsEdinburgh102/03/201824.77
5Sam DailleyMt Kelly1Edinburgh International Inc British ChampionshipsEdinburgh102/03/201825.19
6Santos VillalonMillfield1Edinburgh International Inc British ChampionshipsEdinburgh102/03/201825.27
7Ben HooperHillingdon0ESSA 68th National Inter-Divisional ChampionshipsK2 Crawley125/03/201825.33
8Alex MasonMt Kelly1Edinburgh International Inc British ChampionshipsEdinburgh102/03/201825.35
9Jakob GoodmanMillfield0Millfield Super SeriesMillfield131/03/201825.39
10Archie GoodburnWarrender Ba1Scottish National Age Group ChampionshipsTollcross128/03/201825.42
11Ewan SmithWoking0Crawley Spring OpenCrawley108/04/201825.62
12Thomas CarswellTadcaster0Edinburgh International Inc British ChampionshipsEdinburgh102/03/201825.65
13Lewis KerrodCo Leicester0Edinburgh International Inc British ChampionshipsEdinburgh102/03/201825.73
14Neil WyliePrescot0ESSA 68th National Inter-Divisional ChampionshipsK2 Crawley125/03/201825.78
15Euan MacmurchieDouglas0Beckenham SC 125th Anniversary International OpenLondon131/03/201825.9
16Alisdair StoutCo Manch Aq0City of Sunderland National QualifierSunderland125/03/201825.94
17Jacob St-GermainMillfield0Millfield Super SeriesMillfield131/03/201825.98
18Adam MetcalfEllesmere Co1City of Sunderland National QualifierSunderland124/03/201826.02
19Giano NapolitanoBellshill0Scottish National Age Group ChampionshipsTollcross128/03/201826.03
20Callum RichardsAST Burnham0Edinburgh International Inc British ChampionshipsEdinburgh102/03/201826.06
21Daniel MorleyDerwentside1City of Sunderland National QualifierSunderland124/03/201826.07
22Charlie PooleCo Leicester1Edinburgh International Inc British ChampionshipsEdinburgh102/03/201826.09
23Harry StaceyAberdeen Per0Edinburgh International Inc British ChampionshipsEdinburgh102/03/201826.11
24Robin BoydenMid Sussex0Crawley Spring OpenCrawley108/04/201826.19

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top