Posts by FrankieBue

    Good morning,


    hello to all those who will help me solve what I describe below about scraping HTML and CSS data to load on my Excel worksheets, which I already do by XHR.


    I want to download the data of each row for each table from https://www.betexplorer.com/so…/ac-milan-parma/MDHtcf5J/



    I need to inspect "Standings" about the box "Overall" to download the data what I need, as shown in the image I have attached above.

    I need also to inspect "Standings" about the boxes "Home" and "Away", always to download the data what I need.

    Therefore I need to download the data by inspecting the box "Form" about the "last 5 played games" shown in the boxes "Overall", "Home" and "Away".


    The problem I encountered is that only by selecting each box I can see the tables with the data I need.

    If I don't select them nothing appears in the HTML code of the inspected page so as to find among CSS what i need to download.

    How can we solve what i'm searching for?


    Many thanks in advance to everyone who will come to my aid.

    Frankie.

    Re: Search 1st and Last occurence about certain values through duplicate rows


    Hi dear shknbk2,


    Thanks for your interest.


    About the result 2,37 2,62 2,87...
    they are shown only as example as you read ... they aren't ones values to choose...
    all values are to be chosen...


    On 10th row 2,37 3,10 2,62 are lasts occurrences (goias game) that must be obviously chosen and recorded along range AZ:BB...


    The image posted is only a clarification of what i'm searching for.


    All values are to be chosen and saved in ranges i explained according to 1X2 if firsts or lasts occurrences as i wrote.


    If you have any solution share it so we work about togheter.
    Thanks for your time.


    Frank.

    Hello dear Friends,


    For Each Row having Same Values in Columns A B C D …
    For Columns J M P …



    I'm searching through various criteria...
    the first and last occurrence about values in columns JMP...
    for areas of duplicate values in column ABCD... AS SHOWN:



    [Blocked Image: http://i60.tinypic.com/5d5tvq.jpg]





    On the firsts rows... (those highlighted rows in bleu - starting odds line):



    1) Search for the first occurrence in each column J M P...
    2) Get the value ...
    3) Save it (according to 1X2 Columns J M P positions) in RANGE AW:AY...





    On the lasts rows... ( under highlighted starting odds rows - the closing odds line :(



    1) Search for the last occurrence in each column J M P...
    2) Get the value ...
    3) Save it (according to 1X2 Columns J M P positions) in RANGE AZ:BB...



    For example:





    -) the game coritiba cruzeiro from 5th until 2nd row...



    It starts on 1 (J5) with value 2,87 (AW2:AW5)
    It finishes on 1 (J2) with value 2,87 (AZ2:AZ5)
    '__________________________________________________________





    -) the game goias fluminense from 22nd until 10th row...



    It starts on 1 (J22) with value 2,37 (AW10:AW22)
    It finishes on 1 (J10) with value 2,37 (AZ10:AZ22)
    It finishes on X (P10) with value 2,62 (BB10:BB22)
    '__________________________________________________________





    -) the game estudiantes belgrano on 39th row



    It starts with 2,37 on 1 (J39) so we record it in (AW39:AW39) and finishes also with 2,37 on 1 so we record it in (AZ39:AZ39)
    It starts with 2,87 on X (M39) so we record it in (AX39:AX39) and finishes also with 2,87 on X so we record it in (BA39:BA39)
    '__________________________________________________________





    I hope that I have made it clear... i can't do better!



    Every suggestion and every form of help is appreciated;
    preferably in the form of Excel formula (also vba),
    such as to understand the process of what I research.





    Many thanks in advance to everyone who will come to my aid.
    Frankie.

    Re: Search certain values on duplicate rows


    Coming to practice ... I wish to search for each match (for identical values in column ABCD) the value of the first occurrence and the last occurrence for each value 1X2 (may happen to find even a single line, here are the values of the occurrences identical, being first and last in a same row)...


    Any suggest?

    Re: Search certain values on duplicate rows


    I ask to be sought only values 2.37 2.62 2.87 ...



    1) when they appear on the first lines...
    ( The highlighted rows in bleu as shown in the image below)



    these sought values (having the same values in column abcd) have to be recorded along all lines in RANGE AW:AY...



    2) when they appear as lasts... under highlighted starting odds rows of the other recorded shown rows ...
    ( under highlighted starting odds rows as shown in the image below )



    these sought values (having also the same values in column abcd) have to be recorded along all lines in RANGE AZ:BB...


    [Blocked Image: http://i60.tinypic.com/wjymg2.jpg]


    For example:



    -)the game coritiba cruzeiro from 5th until 5nd row...



    It starts on 1 (J5) with value 2,87 (AW2:AW5)



    It finishes on 1 (J2) with value 2,87 (AZ2:AZ5)



    '__________________________________________________________



    -) the game goias fluminense from 22nd until 10th row...



    It starts on 1 (J22) with value 2,37 (AW10:AW22)



    It finishes on 1 (J10) with value 2,37 (AZ10:AZ22)



    It finishes on X (P10) with value 2,62 (BB10:BB22)



    '__________________________________________________________



    -) the game estudiantes belgrano on 39th row



    It starts with 2,37 on 1 (J39) so we record it in (AW39:AW39) and finishes also with 2,37 on 1 so we record it in (AZ39:AZ39)



    It starts with 2,87 on X (M39) so we record it in (AX39:AX39) and finishes also with 2,87 on X so we record it in (BA39:BA39)



    I hope that I have made it clear... i can't do better!



    Every suggestion and every form of help is appreciated;
    preferably in the form of Excel formula (also vba),
    such as to understand the process of what I research.





    Many thanks in advance to everyone who will come to my aid.
    Frankie.

    Re: Search certain values on duplicate rows


    -)the game coritiba cruzeiro from 6th until 3rd row...
    it starts on 1 with value 2,87 (aw3:aw6)
    It finishes on 1 with value 2,87 (az3:az6)


    -) the game goias fluminense from 19th until 7th row...


    It finishes on 1 with value 2,37 (az7:az19)


    -) the game estudiantes belgrano on 2nd row
    It starts with 2,37 on 1 (aw2:aw2) and finishes also with 2,37 on 1 (az2:az2)
    It starts with 2,87 on X (ax2:ax2) and finishes also with 2,87 on X (ba2:ba2)

    Re: Search certain values on duplicate rows


    Dear Jindon Hello,


    I ask only to be sought values 2.37 2.62 2.87 ...


    1) when they appear on the first lines...
    ( The highlighted rows in bleu or green or gray as shown in the image that i posted )


    these sought values (having the same values in column abcd) have to be recorded along all lines in RANGE AW:AY...


    2) when they appear as lasts... under highlighted starting odds rows of the other recorded shown rows ...
    ( under highlighted starting odds rows as shown in the image that i posted )


    these sought values (having also the same values in column abcd) have to be recorded along all lines in RANGE AZ:BB...


    I hope that I have made it clear...


    Now tha i think... as you suggested...


    could we work alongside the columns where we'll record the search for values 2,37 2,62 2,87 ...
    six more columns next?
    where we'll record other values from 2,37 2,63 2,87 ?
    providing that these are only "those initials" and "finals ones"...


    Also on an other project/worksheet sample...
    thank you very much in advance dear... for your time and your patience...


    frank.

    Hi Friends,



    As shown for example in RANGE AW:AY... for the "Starting Odds"
    As shown for example in RANGE AZ:BB... for the "Closing Odds"



    as in the following image…





    [Blocked Image: http://i58.tinypic.com/2jd0xer.jpg]





    I'm searching…



    For Each Row having Same Values in Columns A B C D …



    For Columns J M P …



    If there are 2,37 2,62 2,87 values… on the (first) starting odds line (those highlighted rows in bleu or green or grey)
    show them, according to 1X2 (Columns J M P) positions, in RANGE AW:AY...



    If there are 2,37 2,62 2,87 values… on the closing odds line (the lasts... under highlighted starting odds rows)
    show them, according to 1X2 (Columns J M P) positions, in RANGE AZ:BB...



    I attach a sample file for greater understanding.



    Some Rows are singles... As shown in the attached file and through the image I posted... on the 2nd row.





    Every suggestion and every form of help is appreciated;
    preferably in the form of Excel formula (also vba),
    such as to understand the process of what I research.



    Many thanks in advance to everyone who will come to my aid.
    Frankie.

    Re: Searching for Duplicates Solved


    Thanks both Guys.


    You were Great Great Great!!!


    I don't know what to say!!!




    I appreciate both of your cycles.


    I preferred to jindon for speed.



    I prefer regard to routine understanding the cycle of Derk.


    Many thanks to both still!!!


    I am speechless before your dedication and professionalism.



    Thanks again.


    I'm very very happy!!!!



    See you soon.


    Frank.

    Solved: Searching for Duplicate group in separate block


    Quote from jindon;749707

    OK you have duplicate group in separate block...


    What a great thing You've solved to me jindon.
    Great Great!!!
    Really thanks!!!



    Many thanks to You and to Derk.


    Nice to have met You.
    See You next time.


    Really thank You again.



    Frank.

    Re: Searching for Duplicates


    Hello guys,



    I think we are close to the solution of what I want.



    jindon thank You for Your time, thank You again also Derk.





    As can be seen from the file that I enclose,



    jindon, Your macro works... just that there are still errors how I wish to be populated and chained values for each row.




    Guys there is an alternative to UBond ???



    Let me explain:



    For the search for values, can we use a for loop next...
    where the values are taken as follows ?



    - ) from the 2nd row
    - ) to the last non-empty row... in reference to column A ?



    ... For i = 2 to last_format_row ... ?




    Thanks so much to You for dedicated time to what I want.
    I await Your solutions.


    I apologize to attach the sample as follows:


    https://www.dropbox.com/s/26jo…ear.To.Solution.xlsm?dl=0
    http://wikisend.com/download/945512/Near.To.Solution.xlsm



    Frank.

    Re: Searching for Duplicates


    Quote from Derk;749634

    I think I now understand what you would like. I am out of time today to make changes, but will do so tomorrow.


    You are great.
    Thanks for understanding what I want.


    See You tomorrow Derk.


    Many Thanks again.



    Frank.

    Re: Searching for Duplicates


    Hello Derk,



    with great pleasure I thank You for having solved in part what I want.



    One last thing is missing:



    I try to be concatenated only duplicate values... as highlighted in red in the N O P columns.
    Those values that occur only once should not appear in the result of the concatenation.



    [Blocked Image: http://i62.tinypic.com/156qna1.jpg]


    As shown in columns Q R S, I think that the posted image will clarify even better the result I want.


    I wait patiently for you.
    forum.ozgrid.com/index.php?attachment/65808/


    You are a BIG!
    Many Thanks again.



    Frank.

    Hi Friends ,
    As shown for example in Col N O P... as in the following image…


    [Blocked Image: http://i62.tinypic.com/24641oi.jpg]


    I'm searching…


    For Each Row having Same Values in Columns A B C D …
    If there are some duplicates


    For Columns F I L
    -> Finding Duplicates
    -> Ordering from the Smallest to the Biggest (They can't be also ordered)
    -> Concatenating of them (also not ordered)


    I attach a sample file for greater understanding.


    Every suggestion and every form of help is appreciated;
    preferably in the form of Excel formula (also vba),
    such as to understand the process of what I research.


    Many thanks in advance to everyone who will come to my aid.
    Frankie.