Apple Event: May 7th at 7 am PT
sorry I'm a complete newbie, i just wonder if anyone could help with this problem:
I'm trying to generate a multi row and column values by entering a key criteria on a field (similar to the filter function of a Mac numbers ), is it possible to do this on an iPad at all?
heres a screenshot of what I'm trying to achieve. Thanks
iPad Air, iOS 8
Hi dfg18,
The quickest way to get what you want would be to do a sort on the relevant column. That would group all the Years or Names or olors together. Further sorts could group, for instance, Black Audis. This might be the best way to go if you want that kind of refinement.
quinn
dfg18 wrote:
similar to the filter function of a Mac numbers ), is it possible to do this on an iPad at all?
You can set up the various filters you want in Numbers on the Mac, sync the document over to iOS and turn the filters on or off on your iPad. To do that tap the table with the filter, tap the "paintbrush", the Table tab, Table Options and then turn the Filters switch on or off.
SG
thanks for your help SGIII, but using filters is not dynamic enough for what my needs. Is there a formula to do exactly like what's on picture on the right ?
dfg18 wrote:
Is there a formula to do exactly like what's on picture on the right ?
There are ways that involve constructing index columns in your original data table. However, it is probably easier to set up filters on each of several "cloned" tables and turn those filters on and off on the iPad.
You can clone a table like this:
Put this in cell A1 and copy it right and down:
=INDEX(Table 1::A,ROW())
The values in the cloned table will then update when you change the original table. You would then set a different filter on each cloned table.
SG
Help with iPad numbers
