none
Eliminating Columns and Rows RRS feed

  • Question

  • I have a spreadsheet. Latitudes are across row 1. Latitudes are across row A. The lower case letters are values of some function. I would like to delete all the columns and rows in the spreadsheet except for those that are closest to .00, .25,.50, .75.

    For example, this

    A

    B

    C

    D

    E

    1

    -91.5125

    -91.5042

    -91.4959

    -91.4875

    2

    42.52124

    a

    b

    c

    d

    3

    42.5129

    e

    f

    g

    h

    4

    42.50457

    i

    j

    k

    l

    5

    42.49624

    m

    n

    o

    p

    would turn out to this...

    A

    B

    1

    -91.4959

    2

    42.49624

    o


    How would I go about doing so?

    • Edited by Philly2034 Tuesday, June 10, 2014 8:45 PM
    Tuesday, June 10, 2014 8:44 PM