Numbers is a spreadsheet software included in the iWork productivity suite by Apple.
0
votes
1answer
25 views
Aligning split columns in a spreadsheet
I'm using Numbers, but I think excel users would also know the answer here.
All I want to know is, how can align the 'amount' column with the columns below it, and the 'total' column with the ...
0
votes
0answers
21 views
Minus 1 from a set of cells in Numbers
I have a range of cells in one columns in Numbers that I wish to reduce by 1. Is there a simple way?
The contents of each of those cells is different though but all are 100% numbers.
0
votes
0answers
15 views
Numbers: How to display two different types of values in cell / label formats?
I'd like to use a custom cell / label formats with two different types of values on my pie charts, a percentage and the absolute number for each peace. Something like this:
60% (12)
40% (8)
How can ...
2
votes
1answer
80 views
0
votes
1answer
18 views
How does one add all values that occur before a specific date?
I know I need the SUMIF function, but I can't figure out the condition for the life of me. Given the following table, how would I get $150?
Value | Date
------+---------
$100 | 1/1/2013
$50 | ...
1
vote
1answer
187 views
Numbers conditional formatting based on a different cell in the same row
I have a Numbers spreadsheet, with "quantity required" and "quantity in stock" columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # ...
2
votes
1answer
138 views
Sum the first N elements in a spreadsheet column
I'm trying to sum the first N elements in a column, where N is a value in another cell.
I've come up with this:
=sum(B1:indirect(concatenate("B", A10)))
Where A10 contains N. But I don't want to ...
0
votes
1answer
197 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
186 views
Quickly increase/decrease cell value by 1 in Numbers
Is there a quick way to increase/decrease a cell value by 1 in Apple iWork's Numbers?
5
votes
5answers
475 views
Does any spreadsheet allow you to create your own functions?
I've always been frustrated when using spreadsheets by the inability to define my own functions when there is no existing function to (cleanly) do what I want. Does any spreadsheet offer this ...
0
votes
2answers
2k views
Pull row of data from one place in spreadsheet to another
I have a list of names and their assorted properties.
I am trying to find a way to quickly move an entire row's worth of data into a different sheet so I can manipulate it.
Currently I can ...
2
votes
0answers
123 views
In Numbers for Mac, possible to have custom formatting depending on value of other cell?
I have several columns of numbers, and I want to highlight one of those with a background color.
I have created a single cell at the top of these columns, that for each column contains either a 1 ...
1
vote
1answer
153 views
Ms Excel or Apple Numbers import rules
I have an Excel file from which I need to export specific colums and place them in a separate file. Is there a program in Windows or Mac, which allows me to set the rules and have these saved for ...
3
votes
2answers
2k views
How to break a spreadsheet containing CSV into multiple columns?
I'm working on preparing data for export, and the client has put all of the data into a spreadsheet. Each field of data should be its own column. The problem is that the client erroneously put ...
1
vote
1answer
523 views
using a formula across sheets in numbers
I have a numbers spreadsheet and am making a totals page to take the totals from each page, add them together in an overview sheet and was wondering if anyone knew how to create a formula to do t
0
votes
1answer
177 views
How to create a line diagram with non-linear date points?
I have a spreadsheet with numerical data like this:
01.01.2011 | Val1 | Val2 | Val3
03.01.2011 | Val1 | Val2 | Val3
03.01.2011 | Val1 | Val2 | Val3
05.02.2011 | Val1 | Val2 | Val3
17.02.2011 | Val1 | ...
0
votes
1answer
132 views
Make a differentiated barchart using numbers
I have a question about Numbers.
I want to make a bar chart that shows the membership of my organisation.
I want to divide between unitary organisations and membership organisations, so i want ...
0
votes
0answers
32 views
Chart from groupings
Given such a spreadsheet:
col1 | col2 | col3
-----+------+----
alfa | foo | 10
beta | foo | 20
gamma| bar | 12
delta| bar | 42
I'd like to generate a chart grouping values from col2 and ...
1
vote
1answer
104 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 ...
1
vote
1answer
206 views
Spreadsheet formula to count consecutive values in a column
I have a column with "Y" and "N" values, and need a formula to count the last consecutive occurrences of "Y". So if I the column looks like this:
Y
Y
Y
N
Y
N
Y
Y
the desired result would be 2
Y
Y
...
1
vote
1answer
181 views
How to reformat all columns to be hyperlinked in apple numbers?
I have a large spreadsheet where one of the columns has text hyperlinks. They are not clickable though.
I can make them clickable by selecting url text and clicking Insert -> hyperlinks -> webpage.
...
0
votes
1answer
132 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.
2
votes
1answer
800 views
What is the Numbers equivalent of F2 in Excel?
What is the Numbers equivalent of F2 (edit cell) in Excel?
3
votes
2answers
751 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 ...
1
vote
3answers
2k views
Auto-fill rows between two cells in iWork - Numbers (or MS Excel)
This is my table
...A............
1 1
2
3
4
5 9
I know the minimum value (A1=1) and I know the maxiumum value (A5=9). Now I want to fill the rows in between with the numbers leading up to ...
1
vote
0answers
331 views
How to plot this in iwork-numbers
I got an array of data like this
0,1
0,56
0,4
0,57
0,6
0,006
0,34
0,46
...
But I got another array of data that classifies the data above in categories like this:
from 0,1 to 0,5 category A
from ...
2
votes
4answers
788 views
Export to csv options using Numbers
I'm using Numbers on my Mac at the moment and exporting to a CSV file. Is there a way to enclose every value with ""?
For example I'm getting the csv file like this:
1,2,3,4,5,6,7,8,9
When I ...
0
votes
2answers
1k views
Apple Iwork Numbers: How to conditionally highlight a cell
I am using apple numbers to do some modeling.
(For those of you who are not familiar it is the apple version of excel that makes awesome looking charts, but has a bit less functionality).
I am ...
1
vote
2answers
383 views
Not counting values if strikethrough in iWork- Numbers
I'm building a holiday expense planner and I'm trying to get the sum of a column in a table, however as I pay things off I want to be able to strikethrough the amount and then it minus it from the ...
3
votes
2answers
10k 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.
1
vote
1answer
72 views
How to assign a shape to each series of values in iWork '09 Numbers?
How can I assign a shape to each series of values in iWork '09 Numbers? Currently all series are forced to have the same shape, which makes them hard to distinguish on black and white prints.
0
votes
2answers
2k views
iWork Numbers: how to copy only filtered values?
I'm using Apple's iWork Numbers to look through some big spreadsheets of economic data. I used the Sort & Filter Panel to filter out just the rows of data I need, and now I'd like to copy just ...
0
votes
2answers
183 views
Is there a key or combo to edit a formula in Apple's Numbers without using the mouse?
In Excel (and OpenOffice) I could use F2 to edit the existing formula. So far the only 'shortcut' I've found in Numbers involves clicking the mouse. Since I'm going from moving with the keyboard to ...
0
votes
1answer
1k 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
