Posts by eugz

  • Delete rows

    Hi All.
    In my huge spreadsheet I need delete rows which are not completely the same. The diferece is page number. For example,
    A1:A2
    05.083 10.27.54 000001 RPT
    GENERAL LEDGER 03/24/05 PAGE 1
    ....
    A1078:A1079
    05.083 10.27.54 000022 RPT
    GENERAL LEDGER 03/24/05 PAGE 22
    ....
    A29910:A29911
    05.083 10.27.54 000566 RPT
    GENERAL LEDGER 03/24/05 PAGE 566     and so on.
    Is it posible to delete such rows in a spreadsheet? Thanks.

  • Delete block of rows

    Hi All.
    I have a huge spreadsheet and I need delete block of rows. First row of block beginning with characters QWD and last row of block beginning with characters FTC. For instance, block of rows start row with QWD and last row FTC:
    798
    4654
    3211345
    11654
    QWD
    LKJ
    LMN
    KL
    FCT
    656
    46546
    6456546
    6546
    QWD
    LR
    LPL
    UJ
    FCT
    How to delete such block in whole spreadsheet? Thanks.