Numbers is a spreadsheet software included in the iWork productivity suite by Apple.

**0**

votes

**0**answers

16 views

### Percent Completion Pie Chart in Apple Numbers

I want to create a pie chart in Apple Numbers with two data sources. I want the percent completion of a goal. Let us say the goal is 4 and so far we completed 1. I would like to have both 1 and 4 ...

**0**

votes

**0**answers

29 views

### Label distribution and scaling in Numbers

I'm currently working in OS X Numbers on a document with two columns and 1078 rows.
Using this data, I have constructed a simple 2D line graph which I am fairly happy with.
The issue that I'm having ...

**0**

votes

**1**answer

80 views

### Spreadsheets Formula Check In/CheckOut Autopopulate Data

I am working on a spreadsheet (I am doing it in Numbers since it will easily let me work on the file on my mac, iPhone, iPad and online at icloud.com)... but this is essentially also an excel question ...

**0**

votes

**1**answer

13 views

### Val2 function in iWork Numbers?

Is there equivalent Excel Val2() function in Numbers? I want to get value of a cell, which contains formula. What I need to get the result text from the cell.
The following is example data:
A B ...

**0**

votes

**0**answers

13 views

### How to enable excel-style table headers in Numbers in Mac?

I'm used to using excel for wading through large data sets using the "table headers" feature, which looks like this:
How to do something similar on a mac using iWork's Numbers?

**0**

votes

**0**answers

42 views

### iMac Numbers - jumping between sheets

How can I jump from one cell in a Apple Numbers sheet to another cell in another sheet within the same spreadsheet with a single mouse click?

**0**

votes

**0**answers

17 views

### Exporting Contacts from Address book to Numbers on Mac

I am able to drag and drop contacts into Numbers where it creates a table with all the information.
However, in the Address book several people have multiple 'work' phone numbers, or multiple ...

**1**

vote

**0**answers

70 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

**0**answers

59 views

### Numbers 3.2 (current) How to set a column data reference permanently

I'm struggling to figure out how to do what I want. I have a nice chart made with my data structured the way I want, however I find it a pain everytime I add a row to re-choose/edit the Data ...

**0**

votes

**0**answers

30 views

### Make a column be unaffected by any row in Excel?

Basically I want to keep a particular column unaffected by any row deletion (by unaffected, I mean no contents of that column are shifted). Is this even possible?

**1**

vote

**1**answer

430 views

### Categorizing data based on a column in Numbers 3.X

I have recently migrated to numbers 3.0.1 on my MAC. I am not seeing the option "Categorize by this column" anymore. Any idea how do we group the data in new numbers based on a column.

**0**

votes

**2**answers

68 views

### Define a range based on the result of the INDEX function

In Excel it is possible to write a function looking like that:
=SUM(A1:INDEX(...))
Where the end of the range of the data to sum is dynamically defined by the result of the INDEX function.
The ...

**0**

votes

**1**answer

111 views

### How can I do this in spreadsheets?

Let's say you have a table like this:
| A | B | C |
-------------------------------------
1| sex | age | answer q1 |
-------------------------------------
2| ...

**-1**

votes

**1**answer

70 views

### Rearranging spreadsheet data

If I have the following data table:
Country 1990 2000 2010 LEB 1990 LEB 2000 LEB 2010
Afghanistan 15 17.72 18.24 48.60 54.86 59.61
...
How would I in an automated ...

**0**

votes

**1**answer

46 views

### How do I lookup using 2 values, Verticle and Horizonal? (Apple Numbers)

I have a sheet that has an individuals info, one table as their Age (TABLE 1). Another Table has a score in cell (TABLE 2). I want to lookup the VALUE that corresponds with their age and score in ...

**0**

votes

**1**answer

23 views

### In one end of table cell, concat all text from Cell A when Cell B is blank

I've got a spreadsheet of potential expenses in Numbers.app.
Text String | $Price
In some rows, the $Price cell is empty.
I'd like to iterate over all the rows, and when $Price is empty, CONCAT ...

**0**

votes

**1**answer

178 views

### Numbers/Excel Hour Counter within Specified Date Range

The data shown in the image is just sample information but...
I would like to use the "Period Beginning" and "Period End" to create a range to determine the total number of hours and earnings. I ...

**0**

votes

**2**answers

108 views

### Excel/Spreadsheet - formula for last value in a row?

I'm trying to forecast increasing vendor costs in a spreadsheet.
My sheet looks something like this
col | A | B | C | D | E | F
vendor | 2013-09 | ...

**0**

votes

**1**answer

71 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 ...

**2**

votes

**1**answer

740 views

**0**

votes

**1**answer

28 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 | ...

**2**

votes

**1**answer

820 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 = # ...

**3**

votes

**1**answer

632 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

**1**answer

335 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

**1**answer

673 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

**5**answers

899 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 ...

**1**

vote

**2**answers

17k 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 ...

**3**

votes

**0**answers

183 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

**1**answer

193 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

**2**answers

10k 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

**1**answer

3k 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

**1**answer

320 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

**1**answer

170 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

**0**answers

38 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

**1**answer

131 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

**1**answer

618 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

**1**answer

796 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

**1**answer

173 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

**1**answer

2k views

### What is the Numbers equivalent of F2 in Excel?

What is the Numbers equivalent of F2 (edit cell) in Excel?

**3**

votes

**2**answers

2k 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

**3**answers

4k 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

**0**answers

382 views

### How to plot this in iwork-numbers

I have an array of data like this
0,1
0,56
0,4
0,57
0,6
0,006
0,34
0,46
...
I have another array of data that classifies the data above in categories like this:
from 0,1 to 0,5 category A
from ...

**3**

votes

**4**answers

1k 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

**2**answers

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

**2**answers

466 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 ...

**7**

votes

**2**answers

14k 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

**1**answer

85 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.

**2**

votes

**2**answers

3k 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

**2**answers

613 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

**1**answer

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