Questions tagged [numbers]

A spreadsheet application developed by Apple as part of its iWork suite availble for iOS, macOS and cross-platform via iCloud. It is the Apple alternative to Microsoft Office Excel.

Filter by
Sorted by
Tagged with
1
vote
1answer
263 views

Get values from Numbers.app into AppleScript's variables

I have a .numbers file in following format: Product Quantity Price Apple 5 3 Banana 7 2 Orange 3 4 I need to get three variables with new-line separated values, e.g. ...
0
votes
0answers
25 views

Numbers function that returns the location for the current cell

It appears that Numbers does not have user defined functions so I am writing a rather complicated expression in Emacs and then pasting it into the cell to use as an equation. I'd like to reference in ...
1
vote
0answers
11 views

Is there a function in numbers that allows to select elements that have an index congruent to 2 modulo 3 for its row, from a given column?

I want to select and do the average of one every 3 numbers and the row index of the first is 5. So I want to select 5,8,11 etc Is there a way to do it in Numbers?
1
vote
1answer
51 views

How to have Farsi/Persian font in a single column of Numbers

I've got a spreadsheet in Numbers which was a .xlsx file previously. In Windows I used to have one the columns of this spreadsheet to be shown in a Farsi/Persian/Iranian font. This column is only ...
1
vote
0answers
10 views

Have an X-axis per year in a Numbers 2D-line chart

I have a sheet in Numbers where I once a week input the current reading from our electricity meter like below: | Date | Reading | | per day | |------------|------------|-------...
0
votes
1answer
50 views

Is there a way to reverse the order of rows in a chart?

I'd like to change this chart to the following one: So, I'd like to reverse the order of rows. According to an answer on a similar question, you need to create a formula and put it in each cell ...
1
vote
0answers
28 views

Is it possible to “lock” and prevent adding new columns in Numbers?

Is it possible to lock the number of columns in a Numbers sheet so that no new columns are added on the right when tabbing through cells? The problem is when I tab through cells from left to right, ...
2
votes
1answer
38 views

Can I use variable in Numbers cell formula?

I have to write a complex formula like this: IF(5−SUM(C35:I35)>0,5−SUM(C35:I35),"") Can I define a variable for 5−SUM(C35:I35)?
1
vote
2answers
684 views

The index.xml file is missing

I like using numbers 2.2 but also have 4.3.1 installed. I would much rather use 2.2. as its been working all along and because I like the format bar which is not in 4.3.1. I've been using "Open With"...
2
votes
0answers
26 views

How do I check if a date is between 2 dates?

In the above example, how would I get the “period” (column C of the Example table) of a certain date (column B of the Example 2 table) using the start and end dates (columns A and B of the Example ...
1
vote
0answers
452 views

Numbers - “the index.xml file is missing” [closed]

I am running OS X Yosemite on my Mac 10.10.5. I have Numbers files saved. When I try to open them, I get "The index.xml file is missing." How do I open these files?
2
votes
0answers
18 views

Paste a formula in numbers 4.2 without altering format of recipient cell

How do i paste a formula in numbers 4.2 without altering format of the target cell? I’m sure this used to be easy, but can't seem to do it. I want to paste a formula from a colour filled cell to a ...
2
votes
1answer
186 views

Numbers error: not enough space in iCloud

I recently maxed out my iCloud storage for a few weeks, meaning things like backups and photo uploading would not work. Eventually, I deleted some unwanted files, and now there is plenty of free space ...
0
votes
1answer
69 views

How can I find duplicate adjacent cells in Numbers?

I have a Numbers sheet that is thousands of rows long. As an example in the image, the sheet has two columns with URLs. What I need to do is find the rows that have the same URL in the two adjacent ...
1
vote
0answers
7 views

Is there any way to make a dynamic line chart?

I am visualizing my net worth monthly since 2014 on a line chart, but since 2017 a certain asset class has been moving exponentially and now the data from 2014 to 2016 looks like a straight horizontal ...
0
votes
1answer
27 views

How do I reference a cell from within a “…IF”-type function condition string?

When using a ...IF type of function (like COUNTIF, AVERAGEIF, etc.), I use condition strings: e.g. ">100", "=Mr. Smith" Instead of using a literal from within the string, how do I (or can I) ...
0
votes
1answer
29 views

Numbers - Perform arithmetic on a section of cells

I have a column of cells and I want to do 41 - (value of cell) for each individual cell without having to go through doing it manually. I know this seems simple but I can't think of an easy and quick ...
1
vote
0answers
10 views

Comparing times in Apple Numbers

I am using the latest version of Apple Numbers on iOS. I have a table with a Date/Time column, with values being: =TIME(0,0,0) =TIME(0,30,0) =TIME(1,0,0) and so on, in half-hour increments, for the ...
2
votes
1answer
34 views

Is there a formulaic way to reverse the order of a list in Apple Numbers?

For example I have a list of numbers in a column. I would like to have another column that takes whatever is in that list and reverses the order the list appears. Is there a way of doing this with a ...
0
votes
0answers
14 views

Numbers : Chart and Percentage

My question is probably ridiculous but I have to admit, I'm lost : I created a Numbers sheet for some electricity bill data. I try to get the percentage of use of the night meter so I did ...
2
votes
2answers
209 views

How can I make calculations based on smart category summaries in Numbers?

The latest version of Numbers has a great feature called Smart Categories that are kind of like Excel's pivot tables. I'm using it to group a table by a label and then sum up spending and revenue ...
1
vote
0answers
9 views

Formatting of negative currency values in Numbers

For some reason Numbers insists on formatting a negative value in a "currency cell" as € 10.99- instead of for example € -10.99. I have tried messing around with the settings in the Language and ...
1
vote
1answer
55 views

How do I turn hyperlinks on or off in Numbers?

How do I turn hyperlinks on or off in Numbers5.2? Sometimes when I paste email or links into numbers they appear as hyperlinks other times not. I cannot seem to find any way of changing these (...
1
vote
1answer
119 views

How to paste information from JSON Helper

I'm able to fetch JSON data using JSON Helper and see the results in Script Editor, under Results. I'm not sure what I would use next in AppleScript to copy those results so I can paste it into a ...
1
vote
1answer
17 views

Disable suggestions as you type on Numbers

It seems that Numbers give a suggestion based on what is already in the sheet. Like in the image. How to disable this?
3
votes
2answers
380 views

Can numbers copy spreadsheet including formula and paste without the figures?

I use the Mac Numbers app (version 5.1) on a retina MacBook Pro, Safari 11.1.2 I need to copy & paste a spreadsheet to include the formulae, but not the figures? Spefically, my accounts for July,...
1
vote
0answers
38 views

Keynote: How to reference a page relative to the current one?

I want to embed tables (from number) in a keynote document. In such a table, I want to reference cells of different tables from different slides. I know that I can address such a table by an absolute ...
0
votes
0answers
11 views

Remove all hyperlinks [duplicate]

Is there any way to remove all hyperlinks from a document? Not only am I stuck with a huge hyperlink fest but I need to be able to select part of the adresses inside the document which numbers doesn't ...
3
votes
4answers
68 views

Find Font used in Numbers

Is there a way to find Font used in Numbers? Opening the spreadsheet on my Mac is fine, but I get this error message when opening the same document on iPad (iOS) The font TIMES-Roman is missing. I ...
0
votes
1answer
23 views

Numbers Sum of all values in a column where another cell within the row matches text

I'm sorry if the title is confusing. I'm struggle bussing hard on figuring out how to write some formula in Numbers. It really doesn't help that the name of the program and functions I'm trying to ...
2
votes
1answer
45 views

Directly input “duration” data type into Numbers formula

I am trying to create a formula in Numbers which takes a duration and calculates what percentage this is of another duration. For example, I have a duration of 1h 30m in cell A1. I want to calculate ...
0
votes
0answers
17 views

How to export with functions / formulas from Numbers?

When using iCloud Number, and exporting to Excel format, it does not export formulas, but the results of of formulas. Why?
1
vote
0answers
16 views

In Numbers, is there a way to find highest value in a row and return its column header?

Expected result: Year Jan Feb Mar Apr May Month of Largest Value 2012 52 89 58 103 90 Apr 2013 92 100 110 20 50 Mar 2014 ...
0
votes
1answer
25 views

Error message “The location of the document “Social Stats record Spreadsheet.numbers” cannot be determined”?

I am trying to save my Numbers spreadsheet and this message (as stated in the question) is showing. I am also trying to export the file as a PDF and this message pops up - The document “Social Stats ...
0
votes
1answer
20 views

Can't swap two columns in a Numbers table by clicking and dragging

I'm trying to swap two rows in a Numbers table, but clicking and dragging on the rows I'm trying to swap is not working at all, like it normally should. What is the problem here?
0
votes
1answer
27 views

How can I describe three different situations on a cell in Numbers

We have business rules as follows: If it is bigger than £35 we charge 75% of it If it is smaller than £20 we charge 70% of it If is is between 20 to 35 we charge 72% of it I don’t know how to ...
3
votes
1answer
24 views

Make chart series rise when number of rows rise

I have spreadsheet that I'm updating every day with new numbers. Each day I'm adding new number to new row. I need to create chart that has series from those rows but I don't want to edit data series ...
2
votes
1answer
46 views

How do you wrap the title text of a sheet in Numbers?

Wrapping the text of a cell can be done by control clicking and selecting the Wrap Text menu item so that it is checked (or by using the formatting side-bar. However, there is no obviousuly intuitive ...
2
votes
1answer
776 views

Apple Numbers IF rules with checkboxes

I have a column A with checkboxes and a column G with Currency can I do a formula to get the total of G only when the checkbox is not tick? in the same idea, I have some dates in column B, and I ...
1
vote
0answers
27 views

Numbers key combination for “fill down” and “fill right” [duplicate]

I want to be able to fill down certain formulas in a spreadsheet. I DO NOT want to use the mouse or trackpad. I only want to know if there is a key combination like Excel's command+D or command+R I ...
4
votes
1answer
110 views

Counting the number of cells which contain a specific character

I want to count the number of cells which contain the character “1” in an Apple Numbers table row. When the row of cells include (using a space delimiter between cells), 1234 5671 1 8765 6113 2468 ...
1
vote
1answer
66 views

Swap two columns/rows in Numbers

I would like to move column 3 in numbers in between columns 1 and 2. In other words, I would like to swap columns 2 and 3. This is possible in Microsoft Excel. I realize this is possible in Numbers ...
6
votes
1answer
77 views

Does Apple's Numbers support 3rd party plugins / data providers / formulas / functions?

Numbers has the ability to pull in prices for various stocks and currencies. However, I am after the ability for it to pull in prices for various cryptocurrencies, not just BTC, such as Cryptofinance ...
3
votes
2answers
203 views

Numbers: How to escape the “+” character for a phone number

I am working on a document in Numbers where I have to write a phone number starting with a plus character +, like +33553379412, but as soon as I press enter, the plus is going away. Is there any way ...
3
votes
1answer
1k views

Setting the value of a Numbers cell using AppleScript

I'm trying to write a numbers script (to do this, as it happens), in which I need to change the value of a cell. However, if I do something like tell application "Numbers" activate tell ...
2
votes
1answer
93 views

How to print one Numbers row per page, formatted nicely

I have a Numbers spreadsheet consisting of data that I would like to print. However, I would like to have each row of the table printed out on its own separate page. Moreover, each row contains a lot ...
4
votes
1answer
389 views

AppleScript and Numbers: How do I add a row?

This has to be simple: I want to use AppleScript to add a new row at the top of a Numbers sheet called WorkoutSheet in a table called WorkoutDB in a Numbers document call Workout.numbers. (Using ...
2
votes
1answer
825 views

(Numbers) COUNTIF values from one column match another column?

I have a Numbers file containing some rows with machine learning predictions and also what the actual values were. The first column contains an unique ID, the second column contains the actual values, ...
0
votes
0answers
132 views

Numbers 3 or 4: how to copy a chart completely?

I have Numbers 4.3, 3.6 and 2.3 installed on different computers. I want to copy charts from Numbers to Keynote but when I do that in 4.3 or 3.6 the title, legend etc are omitted (and yes, I have ...
3
votes
0answers
80 views

How to find polynomial trendline x value when using a date?

So I have a chart that I have created in Numbers, with a trendline using a polynomial function, and I've got it to display the formula, but I cannot for the life of me, figure out what x value I'm ...