Collection of links in Excel file and removal of duplicates
Data Processing
All links to blogs with 7 sites are collected in more than 1,500 pieces.
The links are removed from the 8th website.
After that, the analysis of the links and the removal of duplicates was performed. The complexity of searching for duplicates consisted in that the links had a different type: with http or https, with www and without www, only the domain or section/page of the site.
The result was 781 unique links.
#excel #exel #access/Excel #Excell #access #MSAccess #word #msword #excel #excel #Tables #Infographic #Graphics #Diagram #Macros #Macros #vba #tableau #Tables #Tables #Delete-Doublicates
The links are removed from the 8th website.
After that, the analysis of the links and the removal of duplicates was performed. The complexity of searching for duplicates consisted in that the links had a different type: with http or https, with www and without www, only the domain or section/page of the site.
The result was 781 unique links.
#excel #exel #access/Excel #Excell #access #MSAccess #word #msword #excel #excel #Tables #Infographic #Graphics #Diagram #Macros #Macros #vba #tableau #Tables #Tables #Delete-Doublicates