Hello, I am a beginner at excel. I am trying to import some data from charts that are on the web using this method:
-Data Tab
-From Web
-Entered Web address.
-Clicked on the yellow arrow where the chart is located on the web page (yellow box, turned green)
-Clicked on Import
THIS IS WHERE MY PROBLEM IS. When the chart loads there are duplicate entries with slightly different variables. Is there a macro or formula that I can utilize to remove the duplicate entries permanently, everytime I am going to refresh the data from the web?