KathCobb Beginner

  • Female
  • from NY
  • Member since Apr 29th 2020
  • Last Activity:
Posts
2
Points
8
Profile Hits
37
  • 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