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

learn more… | top users | synonyms

3
votes
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
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 ...