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

**0**

votes

**1**answer

28 views

### Extended Subtraction Between Columns on same row in area

I want to calculate the transaction value so by that i mean i've got different accounts in column "A" and for each transaction i got a column like "B".
The transactions show the new value, after the ...

**1**

vote

**0**answers

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

**0**

votes

**0**answers

3 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

**1**answer

61 views

### iwork numbers and apple Swift language relation

Is there any way to write Microsoft office Excel macros like scripts for iWork numbers code using apple's Swift programming language?

**1**

vote

**1**answer

11 views

### Full grid canvas in Apple Number

Apple Number have a default blank canvas shaped as a sheet with margins.
Is it possible to change the default blank canvas to an endless grid like Microsoft Excel?

**0**

votes

**0**answers

31 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

**2**answers

103 views

### Find the number of cells to sum to reach a certain amount

I have a column of values (they are ordered if that matters): A:A. I have two values: a starting value B1 which is also present somewhere in A:A, and a goal value C1.
Let's say the we can find the ...

**0**

votes

**0**answers

10 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

11 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

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

**0**answers

72 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

21 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

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

**3**

votes

**2**answers

727 views

### In Excel (or Numbers) what formula can calculate the amount of days in a certain month across 2 dates

If a guest arrived on 24th of August and left on 4th of September what is the formula(s) to calculate how many nights are spent in August, and how many nights are spent in September?

**1**

vote

**0**answers

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

**0**

votes

**1**answer

254 views

### Display Last Value from End of Row in iWork Numbers

In iWork Numbers (v3.5.2) I would like to display the last value (not int or bool) from a row. I have an image of what I'm looking to do below.
In row 1 I have the Current pulling the value from ...

**0**

votes

**0**answers

214 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

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

**1**

vote

**0**answers

257 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

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

**3**

votes

**1**answer

875 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

171 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

179 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

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

**1**

vote

**1**answer

74 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

33 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

333 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 have ...

**0**

votes

**2**answers

153 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

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

**3**

votes

**1**answer

2k views

**0**

votes

**1**answer

36 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/...

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

**3**

votes

**1**answer

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

360 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

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

1k 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 ability?...

**1**

vote

**2**answers

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

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

**1**answer

221 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

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

**2**

votes

**1**answer

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

373 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

304 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

143 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

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

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

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

**4**

votes

**1**answer

3k views

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

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