Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [numbers]

A spreadsheet application developed by Apple as part of its iWork suite. The iWork equivalent of Microsoft Office Excel.

0
votes
1answer
14 views

Numbers not sorting dates correctly

I cannot get the column to sort the dates correctly in Numbers! I want to sort the column by date and instead of sorting 1 through 12, it sorts like this: 1,10,11,12,2,3
0
votes
0answers
8 views

Mac Numbers equivalent to Microsoft Excel's Control+Arrow Keyboard Shortcut

Is there a feature in the MacOS Numbers application that allows me to jump to non-empty cells? In Excel if I hold the control key and press any of the keys ←↑→ or ↓ the cursor will navigate to the ...
0
votes
0answers
9 views

How is it possible to put the X Axis at the top of the chart in Numbers App

I have a vertical line diagramm and I need to put the x axis at the top of the chart. How is it possible? Thanks
1
vote
1answer
16 views

Numbers for macOS: how to update a column of entries

In Numbers for macOS I have a column of entries, each entry (field) is just a single word. How can I update the whole column such that each entry will look like that instead: <img src="...
1
vote
1answer
24 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
16 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 ...
0
votes
0answers
3 views

How to change direction of reference for “close match” in vLookup in Apple Numbers

Currently, when using vLookup, you can only use "close match" to find the closest value less than or equal to your current value. Is there any way to make it find the value closest that is greater ...
1
vote
0answers
8 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
0answers
12 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 ...
0
votes
0answers
19 views

How to collaborate iWork Numbers file with Android

I hope that somebody knows a workaround to a situation. Recently, I needed to share a Numbers file with a large number of coworkers. I used the collaborate option and opened up the file for viewing. ...
1
vote
0answers
7 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
24 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
15 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, ...
-1
votes
0answers
12 views

Is there a way to create custom function for cell formula in Numbers?

Is there a way to create custom function for cell formula in Numbers? Any script is OK, like applescript or python or javascript.
2
votes
1answer
21 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
1answer
41 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
19 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
138 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
15 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
43 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 ...
1
vote
1answer
34 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
22 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
25 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
7 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
21 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
12 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
69 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
8 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
17 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
58 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
14 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
107 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
15 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
58 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
10 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
21 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
14 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
10 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
22 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
0answers
10 views

Custom default row in numbers?

This may be answered already, I wasn't sure exactly how to ask the question in the search bar; if so, please link the answer. Basically, I am making a spreadsheet to keep track of my work hours, ...
0
votes
1answer
10 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
0answers
12 views

Getting filtered data from one table to another in Numbers

I'm creating a "system" that consists of a main table, which collects all my input data, and other sheets, that organize/process the collected data. This main table would consist of three columns: (1) ...
0
votes
1answer
25 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
0answers
17 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
25 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
101 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
17 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
28 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 ...