1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Re: Show only

    From Martin Mattern@21:1/5 to All on Fri Aug 19 15:58:43 2022
    *Edit: 0101-7484 repeats 4 times so I'd want to isolate those 4 rows

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Mattern@21:1/5 to All on Fri Aug 19 15:56:34 2022
    I have a spreadsheet with repeated values in column B, each value repeats at least once. The corresponding value in column A should also repeat as many times as the value in column B repeats.

    If the value in column A does not repeat the same number of times the value in column B repeats then I want to isolate those instances.

    Example:
    column B shows value 0101-7483 repeated 3 times however 1 of the instances has a different value in column A so I would want to isolate those 3 rows.

    Value 0101-7484 does the same thing so I'd want to isolate those 3 rows.

    Value 0101-7485 does not need to be isolated because it has 2 of the same values in column A.

    Column A / Column B
    195.91 0101-7483
    199.95 0101-7483
    199.95 0101-7483
    195.91 0101-7484
    199.95 0101-7484
    199.95 0101-7484
    199.95 0101-7484
    199.95 0101-7485
    199.95 0101-7485

    Thanks for any input!
    -Marty

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From zvkmpw@21:1/5 to All on Sat Aug 20 09:38:04 2022
    *Edit: 0101-7484 repeats 4 times so I'd want to isolate those 4 rows

    What do you mean by "isolate rows?" Inserting blank rows before and after the isolated ones?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)