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

**3**

votes

**1**answer

2k 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 = # ...

**1**

vote

**1**answer

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

**0**

votes

**1**answer

18 views

### Numbering lists in Apple's Numbers

This should be so simple.
I am attempting to use "Numbers" Mac's spreadsheet program. All I want to do is make a list of people and number them. I want the gridlines - and I want the list of ...

**0**

votes

**1**answer

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

15 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

**1**answer

372 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

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

**-1**

votes

**1**answer

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

**3**

votes

**0**answers

215 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

**0**answers

8 views

### Performing calculations on durations in iWork Numbers

I have a time sheet that I use to bill clients, with the following columns:
A: start time;
B: end time;
C: calculation of B - A, resulting in the duration of time worked;
D: Project name
On another ...

**1**

vote

**0**answers

93 views

### Go to specific row number in Numbers (OSX)

Is there a way in Numbers to go to a specific row number?
For example I need to find an alternate way to not have to scroll but rather can immediately go to row # 3000.

**1**

vote

**0**answers

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

**1**

vote

**0**answers

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

**0**

votes

**0**answers

2 views

### formula calculation set to manual in iwork numbers / improve performance

Is there any way to set formula calculation to manual in iwork numbers? I heard it helps in terms of performance improvement in case of microsoft excel. So I am wondering is this trick applies to ...

**0**

votes

**0**answers

27 views

### Mac OS Numbers: Can't merge cells beneath unmerged cells

I used to merge cells with "right click > merge cells". But it doesn't seem to work for cells beneath rows that I have filled with content
In the image above you can see in the first row I have ...

**0**

votes

**0**answers

9 views

### Adding Interquartile ranges for various sets of data

I'm collecting data about the First Robotics Competition. The whole giant organization is split into tons of regional levels, in each about 30 to 70 teams participate and are ranked regionally. They ...

**0**

votes

**0**answers

9 views

### Copy entire row based on content of single cell on Numbers

I have a spreadsheet on Numbers that contains a table of invoices I have received from various companies
Example
When I input data into this table I would like it to automatically copy into ...

**0**

votes

**0**answers

64 views

### Mac Numbers: Finding the last nonblank cell value in a row

I have a numbers spreadsheet where all of the values are numeric, not including the headings. Roughly half of the cells are scattered blanks. Each column represents a certain date, with each date ...

**0**

votes

**0**answers

19 views

### iWork Numbers Stepper Keyboard Shortcut

I'm working in an iWork Numbers spreadsheet with lots of stepper cells:
Is a faster way to increment / decrement these numbers than clicking the mouse, then clicking the stepper arrow? Ideally I'd ...

**0**

votes

**0**answers

26 views

### Numbers or Excel, Sum data in a column depending on date

I hope to Sum Column Y based on data in column A. That is, If A is in (contains) "July", then sum Y. i.e. "What are the totals for July?

**0**

votes

**0**answers

41 views

### Numbers background, get rid of color

A customer send me a Excel file. For different reasons I have to convert the database to Apple Numbers. When I open the Excel file with numbers there are some rows with the background in yellow color. ...

**0**

votes

**0**answers

193 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

**0**answers

49 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?

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