Identify and number Patterns

  • Re: Identify and number Patterns


    okay, thanks Pike or all you have done in helping I do appreciate it your time. I hope you have a Happy Thanksgiving!

  • Re: Identify and number Patterns


    hi
    fill the fomula down to the last row and try..

  • Re: Identify and number Patterns


    okay, I copied this macro and pasted it in a new module? correct> I then dragged down column K. I clicked on fnd next and it did not find the same counter number. It finds a different one. Did I do this correctly?

  • Re: Identify and number Patterns


    or ?


    Code
    Sub simple_search()
       Rows(5).Resize(Columns(11).Find(Join([transpose(transpose(B3:E3))], "^"), , xlValues, xlWhole).Row - 5).Hidden = True
       Rows(Columns(11).Find(Join([transpose(transpose(B3:E3))], "^"), , xlValues, xlWhole).Row + 1).Resize(50).Hidden = True
    End Sub
  • Re: Identify and number Patterns


    Quote from snb;692920

    or ?


    Code
    Sub simple_search()
       Rows(5).Resize(Columns(11).Find(Join([transpose(transpose(B3:E3))], "^"), , xlValues, xlWhole).Row - 5).Hidden = True
       Rows(Columns(11).Find(Join([transpose(transpose(B3:E3))], "^"), , xlValues, xlWhole).Row + 1).Resize(50).Hidden = True
    End Sub


    I need some direction...sry...newbie here, do i delete what Pike suggest? Do i add this to his on the same page? different page? Thaks

  • Re: Identify and number Patterns


    Here is short video that may shed some light. I finally uploaded the video. I noticed that the location number is different in the video. they have to be the same. When I did this quickly I did not copy and paste. Instead It got dragged it down making it count 1,2,3,4,5,6, if there is any confusion on that part. The rest of the video is what I am looking for.


    https://www.youtube.com/watch?v=ZuzYCKSWv9M

  • Re: Identify and number Patterns


    Quote from snb;692938

    why do you think did I use the same name for this macro ?


    I have no clue, as i said i am a newbie. What exactly do i need to do please?

  • Re: Identify and number Patterns


    Quote from larbec;692943

    I have no clue, as i said i am a newbie. What exactly do i need to do please?



    Thanks for the suggestion and I will go to Barnes and Noble and/or Library. In the meantime can anyone help me with this? That is why I came to the forum t get assistance from the Guru's

  • Re: Identify and number Patterns


    Hello,
    so you have two sets of numbers to search between in columns B, C, D and E
    first set eg ... 2,4,3,5
    find the first set of numbers ( in B,C,D and E) and search for the second set eg..4,4,5,2 ( in B,C,D and E)
    display all the number between these two set if they have the sequential numbers in column A and have the same number in column F
    is that correct

  • Re: Identify and number Patterns


    Not quite pike. I needed to make sure when I get my return search they are sequential. Meaning if I had 10 different locations all named something else They would all have the numbers 1,2,3,4,5,6,7,8,9,10 but different location My answer after scan needs to match "location" and be sequential ie.... Location Cat 1, Cat 2, Cat 3. Not. cat 1, Dog 2, Cat 3

  • Re: Identify and number Patterns


    pike


    i appreciate all you've done. I went to the book store and bought VBA for dummies and excel for genius'. I wrote a helper program and it's doing EXACTLY what I want and the complete scan takes less than 10 seconds. Have a Happy Thanksgiving.

  • Re: Identify and number Patterns


    Hi larbec...


    For the love of all things good.. please post your 'Helper program'.. so we can see what you actually needed.. this thread is longer than the Dole queue on Thursdays.. it would be nice to see what was needed in the end..


    And 3 cheers for Pike for sticking with it.. :)


    For non Aussies...


    https://www.google.com.au/sear…0CDUQsAQ&biw=1536&bih=763

  • Re: Identify and number Patterns


    Yes please do. I thought I was beginning to see what was wanted (and thought pike's code addressed that need) but the recent introduction of cats and dogs has sent me back to square one! Or maybe that should be 'sent me back to the end of the queue'. :)

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: Identify and number Patterns


    The cats and dogs was like a widget. Sometimes we get hung up and make things more complicated than they were. That's why I said early on my "internal" program has nothing to do with what I am wanting to do


    Sub ertert()
    Dim x: Application.ScreenUpdating = False
    ActiveSheet.AutoFilterMode = False
    Range("O4").CurrentRegion.ClearContents
    x = Application.Transpose(Range("F3:F10"))
    With Range("A12").CurrentRegion
    '.Columns(7).FormulaR1C1 = "=RC[-5]&RC[-4]&RC[-3]&RC[-2]"
    .AutoFilter 7, x, 7
    .Copy Range("O4")
    .AutoFilter
    End With
    Application.ScreenUpdating = True
    End Sub



    [ATTACH=CONFIG]57695[/ATTACH]



    And absolutely. My gratitude to Pike for hanging in there and not giving up on me. I have been up for the past two days working on this. Ya'll have no idea how this has made my job a lot easier and I was determined to compete it . Pike THANK YOU THANK YOU THANK YOU!!!


    For others ..... telling me to go buy a book is not helping anyone at the present, it helps for the future but when ppl come here for assistance, they should get direction and go buy a book IMHO is not direction. Pike pushed me to learn and I Thank him for that BUT, he also gave me suggestions and did not give up. What gratitude and respect I have for him (Pike) !!!!!!!!!!!

  • Re: Identify and number Patterns


    Quote from pike;693055

    Hello,
    so you have two sets of numbers to search between in columns B, C, D and E
    first set eg ... 2,4,3,5
    find the first set of numbers ( in B,C,D and E) and search for the second set eg..4,4,5,2 ( in B,C,D and E)
    display all the number between these two set if they have the sequential numbers in column A and have the same number in column F
    is that correct


    larbec, You need to explain in logical steps with the data you supplied .what you are doing .. no cats, dogs or waving a cusor around in a video .. step by step logical that we can understand and before and after workbook examples ( no screen shots)
    if you cant write the logical steps which are related to a workbook .. no one can guess what is happening.

Participate now!

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