-------------------------------------------- On Fri, 2/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!! To: excel-macros@googlegroups.com Date: Friday, February 10, 2017, 8:02 AM -------------------------------------------- On Fri, 2/10/17, RamiZ Majid <mera...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!! To: "Kishore P V K" <kishore...@gmail.com> Cc: excel-macros@googlegroups.com Date: Friday, February 10, 2017, 7:47 AM Thanks bro!!! It worked. On Fri, Feb 10, 2017 at 2:09 AM, Kishore P V K <kishore...@gmail.com> wrote: Here is the simple solution for your requirement: Insert a new column before the URL column: Enter the formula as showed in A2 column below after enter the formula in A2 drag the column till the URL values. Then you will find the all domain names in the column A as per the below screen shot Then select the required columns and go to DATA ribbon and select "Remove duplicates" option when option comes just select the newly created column A (Domain) Then click OK. There you go: Hope this helps you !!! Cheers On Thu, Feb 9, 2017 at 3:34 AM, Ramiz Majid <mera...@gmail.com> wrote: I have a list of webpages contacting different domain pages!!! I want to pick a single webpage of each domains!!!! Please help ! This is an example list: And I need this as ..... Thanks! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discu ssexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscribe@googl egroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/grou p/excel-macros. For more options, visit https://groups.google.com/d/op tout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. 83617 febr. - CraGovia Polonia este ocupata de trupele ruse austriece si prusace. - Independenta Texasului care se rupe de Mexic. 29 30 oct. - incercarea lui Ludovic Napoleon de a prelua puterea in Franta. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.n aprilie 1918 s-a constituit la lasi Liga Poporului. Liderul sau era 'xandru Averescu numit in 1930 maresal al Romaniei. Organul de presa era dreptarea . in 1920 a devenit primul partid care avea adepti la nivelul intregii i Guvernul Averescu 1920-1921 a adoptat o serie de masuri importante itru dezvoltarea Romaniei si anume legile de reforma agrara unificare netara reforma financiara primul buget al Romaniei intregite. Framantarile interiorul partidului au dus in 1925 la fuziunea cu resturile Partidului >nservator Progresist. Din cadrul partidului s-au desprins o serie de dizidente. a mai importanta a avut loc in 1932 prin desprinderea gruparii conduse de tavian Goga ce a pus bazele Partidului National Agrar. Ziarul sau era tara astra . Afisand un program in general contradictoriu formatiunea a promovat politica de centru-dreapta. in 1935 a fuzionat cu Liga Apararii Nationale estine formand Partidul National Crestin. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
