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

learn more… | top users | synonyms

8
votes
2answers
16k 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.
5
votes
5answers
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?...
4
votes
1answer
3k views

What is the Numbers equivalent of F2 in Excel?

What is the Numbers equivalent of F2 (edit cell) in Excel?
4
votes
2answers
3k 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 ...
3
votes
2answers
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 ...
3
votes
4answers
2k 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 ...
3
votes
2answers
694 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?
3
votes
1answer
847 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.
3
votes
1answer
2k views

Formula to add X months to a date?

How can I add X months to an existing date in iWork Numbers?
3
votes
1answer
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 ...
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 = # ...
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 (...
2
votes
2answers
5k 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 ...
2
votes
1answer
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
1
vote
3answers
5k 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
2answers
46k 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 ...
1
vote
1answer
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
2answers
515 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 ...
1
vote
1answer
86 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.
1
vote
1answer
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 ...
1
vote
1answer
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?
1
vote
1answer
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. ...
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
1answer
9 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?
1
vote
0answers
105 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
250 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
1answer
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 ...
1
vote
1answer
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
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,...
0
votes
1answer
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, ...
0
votes
2answers
1k 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
2answers
97 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
2answers
159 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
2answers
152 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
1answer
52 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?
0
votes
1answer
174 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| ...
0
votes
1answer
329 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
1answer
139 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 ...
0
votes
1answer
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/...
0
votes
2answers
2k 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 ...
0
votes
1answer
4k 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
0
votes
0answers
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
0answers
28 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
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
0answers
10 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
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
0answers
69 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
20 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
43 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. ...