1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Spreadsheet

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

  1. mgrovum
    Offline

    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
    Offline

    deckyon iPad Junkie

    Joined:
    Sep 15, 2010
    Messages:
    615
    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
    Offline

    gentlefury iPad Guru

    Joined:
    Mar 15, 2010
    Messages:
    2,623
    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
    Offline

    deckyon iPad Junkie

    Joined:
    Sep 15, 2010
    Messages:
    615
    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
    Offline

    gentlefury iPad Guru

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

    deckyon iPad Junkie

    Joined:
    Sep 15, 2010
    Messages:
    615
    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
    Offline

    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
    Offline

    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