Search certain values ​​on duplicate rows

  • 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: 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.

  • 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


    Then what should be done?
    Is the workbook you uploaded is the result that you want?


    Sorry, but I don't think I'm able to understand the logic/algorithm...


    Hope someone else might understand this.

  • Re: Search certain values on duplicate rows


    Yes jindon,


    the workbook i uploaded is the result i want.


    Any help is appreciated.


    Tx for you time dear.


    i hope someone else come to my aid and solve what i'm searching for.


    See you.


    Tx jindon.

  • 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


    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?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!