KathCobb Beginner

  • Female
  • from NY
  • Member since Apr 29th 2020
  • Last Activity:
Posts
15
Points
100
Profile Hits
119
Search Content

  • hi




    how do i count number of rows each time a same value appear from the previous row in vba arrays




    for example A marked in red moved 3times/ rows then 4times and 8times




    A

    B

    C

    D

    E




    C

    D

    N

    E

    G




    A

    H

    I

    L

    G




    B

    V

    J

    O

    Z




    C

    H

    I

    L

    G




    G

    N

    M

    C

    A




    D

    T

    R

    C

    G




    Z

    B

    E

    M

    F




    O

    H

    I

    L

    G




    Y

    X

    Q

    E

    T




    B

    D

    I

    L

    U




    J

    H

    V

    P

    G




    A

    M

    I

    L

    Q