Spreadsheet

Discussion in 'New Member Introductions - Site Assistance' started by mgrovum, Nov 18, 2010.

  1. mgrovum

    mgrovum iPF Noob

    Joined:
    Nov 18, 2010
    Messages:
    3
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Viet nam
    Ratings:
    +0 / 0
    Hi. I would really like to be able to use the Numbers spreadsheet to filter out a few select quotes from a list of say 1000 quotes. Supposing you want to find all the quotes that use the word "ipad" out of a thousand quotes. Can anyone tell if this is possible using Numbers or any other iPad application. It is a snap using MS XL. Morris
     
  2. deckyon

    deckyon iPad Junkie

    Joined:
    Sep 15, 2010
    Messages:
    612
    Thanks Received:
    2
    Trophy Points:
    0
    Location:
    Louisville, KY - USA
    Ratings:
    +2 / 0
    Cant answer on the Numbers, but I checked in DocsToGo Premium and I was not allowed to filter, but I could search. 2 different things, I know.

    I would look at Google Docs (they are now allowing editing on iPads - still being pushed out and should be completely upgraded soon)
     
  3. gentlefury

    gentlefury iPad Guru

    Joined:
    Mar 15, 2010
    Messages:
    2,617
    Thanks Received:
    7
    Trophy Points:
    0
    Ratings:
    +7 / 0
    Yes in Numbers just click the wrench icon in the upper right corner, then choose find:
    [​IMG]

    [​IMG]

    You can do all the standard find functions like find and replace.

    [​IMG]
     
    Last edited: Nov 18, 2010
  4. deckyon

    deckyon iPad Junkie

    Joined:
    Sep 15, 2010
    Messages:
    612
    Thanks Received:
    2
    Trophy Points:
    0
    Location:
    Louisville, KY - USA
    Ratings:
    +2 / 0
    I think he is wanting to filter and show only the rows with a certain term. Not just find them one at a time. Filter =\= Find

    I just tried out this in Google Docs (force Desktop in Safari) and you can filter on any column for text.
     
    Last edited: Nov 18, 2010
  5. gentlefury

    gentlefury iPad Guru

    Joined:
    Mar 15, 2010
    Messages:
    2,617
    Thanks Received:
    7
    Trophy Points:
    0
    Ratings:
    +7 / 0
    Sounds like exactly what I demo'd
     
  6. deckyon

    deckyon iPad Junkie

    Joined:
    Sep 15, 2010
    Messages:
    612
    Thanks Received:
    2
    Trophy Points:
    0
    Location:
    Louisville, KY - USA
    Ratings:
    +2 / 0
    Still, if there is a list of 1000 quotes, and you want to find only the few with a word/phrase, would you rather have to hit find next, or just show the rows that have the word/phrase, excluding the rest; Filtering.

    DocsToGo can Find as well, but man, that sounds more tedious.

    I read it as he was looking for Excel's "Auto Filter" which creates the dropdown where you can enter a word/phrase or select from the list.
     
  7. mgrovum

    mgrovum iPF Noob

    Joined:
    Nov 18, 2010
    Messages:
    3
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Viet nam
    Ratings:
    +0 / 0
    Filtering a spreadsheet

    I tried Google Docs. It works in a fashion, but you have to be on line and that makes it super slow!! Morris in VN
     
    Last edited: Nov 20, 2010
  8. mgrovum

    mgrovum iPF Noob

    Joined:
    Nov 18, 2010
    Messages:
    3
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Viet nam
    Ratings:
    +0 / 0
    They talk about "grouping" and using categories with Numbers; I wonder if that is the same as filtering. I would find out myself, but so far Apple will not let a Canadian in VN set up an iTunes account!!! Morris.
     

Share This Page

Search tags for this page
filter in google spreadsheet on ipad
,

filter rows in numbers for ipad

,

find and replace on the ipad with google spreadsheets‎

,
google docs filter on ipad
,
google docs op ipad filter
,
ipad spreadsheet app with filter
,
ipad spreadsheet apps filtering
,
ipad spreadsheet with filter
,
spreadsheet app for ipad with fitlering