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

learn more… | top users | synonyms

2
votes
1answer
721 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
1answer
191 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
1answer
53 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
1answer
11 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
1answer
45 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
1answer
309 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
169 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
1answer
50 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
0answers
178 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
0answers
53 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
0answers
381 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
0answers
18 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
0answers
12 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
0answers
23 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
0answers
13 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 ...
0
votes
0answers
50 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
0answers
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?
0
votes
0answers
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 ...