1
vote
0answers
15 views

Pull multiple rows of data from one place in spreadsheet to another based on a condion

I have an iWork Numbers (3.2 - 1861) sheet with a list of people with the following structure: | Name | Age |  Email | Condition | | Bart | 12 | test@test.com | ...
0
votes
0answers
107 views

'Categorize by this column' doesn't seem to work with formulas involving current date

I'm creating a table for bill statuses... The status can be paid, unpaid, or overdue. There's a due date column which you can guess is set to the due date. So, I have my Status column, which uses the ...
0
votes
1answer
297 views

Numbers is no longer shipped with OSX from Mountain Lion?

I heave heard that Mac OSX Snow Leopard shipped with Numbers, an app used to manipulate spreadsheets. But I can't find it inside my default Mac OSX Mountain Lion installation. Checking with App Store, ...
1
vote
1answer
124 views

Not showing negative results in Numbers.app

How can I make iWork Numbers not show me negative results? For example: The thing is that in A1 I have number 101 and I am doing -A1 from B1. B1 is empty (because I am waiting for the result) so in ...
0
votes
1answer
170 views

My Numbers Spreadsheet does not show any data

My Numbers spreadsheet shows blank even though it has data in it. What could be wrong? Please see attached image.
3
votes
2answers
1k views

Apple Numbers: keyboard shortcut for “smart fill”?

If I've got some sort of patterned data selected — say sequential numbers — I can click and drag the little circle in the bottom right corner of that selection to “smart fill”. For example: Is ...
7
votes
2answers
13k views

How to interchange a column and row in a table (Transpose) in iWork Numbers?

I want to transpose a table (interchange rows to columns and vice versa). How to do that in iWork Numbers.
0
votes
1answer
2k views

Select each nth row in Numbers

I have an iWork Numbers spreadsheet with thousands of rows. How can I select every 5th row from that spreadsheet? See also: Select each nth row in Excel