Stack Exchange Network

Stack Exchange network consists of 175 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 availble for iOS, macOS and cross-platform via iCloud. It is the Apple alternative to Microsoft Office Excel.

0
votes
0answers
9 views

Date & Due Date - Formula Question

Let's say I have two tables, one with the current date (but where I change it manually.), and the other one with a due date. The current date is 01/01/19, and the due date is set to one day past the ...
1
vote
1answer
10 views

How to write a formula with a reference that adapts to new columns

When writing a reference in a formula like: HLOOKUP(Table1::B$2$;Table2::G$3:K$82;46) have the area referenced adapt to new columns added to Table2. E.g. Table2 has columns from A to K, and every ...
0
votes
1answer
15 views

Calculation in Numbers to figure out the date 5 business days from another date

I have been going around and around but haven't quite grasped some of the key formula concepts. I have a start date and want to add 5 business days to it. Start date + 5 doesn't take into account ...
0
votes
0answers
7 views

Evaluate a formula stored in a cell

Is it possible to store an expression in a cell and then refer to it/evaluate it within other cells? I've found myself repeatedly using complex expressions in cell formulas, e.g., the sub-expression ...
0
votes
0answers
9 views

IPad Air A1474 iOS version 12.1.4 free Numbers App [closed]

How do I get “Numbers” spreadsheet to remember my cell formatting defaults.
2
votes
1answer
64 views

NUMBERS Is it possible to select all the cells that share the same background colour on an existing table?

I have a large(ish) table, which is 75 rows, and 120 columns. so, 9000 cells. They are all empty of data, but some of them have their background fill set to Colour A, and some have it set to Colour B. ...
0
votes
1answer
21 views

How do I unhide columns in Numbers using AppleScript?

How do I unhide columns in Numbers using AppleScript? I created a custom shortcut so that ⌘+U unhides all columns, so I have tried this so far: tell application "Numbers" open POSIX file "/path/...
1
vote
0answers
13 views

How does one separate a Numbers spreadsheet with multiple (4) tabs into separate files?

I have been given a spreadsheet with 4 separate tabs/sheets. I would like to separate them into different files. I know that I can cut-and-paste and create new files but is there a simpler/easier way ...
1
vote
0answers
4 views

Keep a Numbers chart stationary while scrolling the page?

In Numbers, is there a way to make a chart stay visible at the top of the page while I scroll down through the rest of the page's contents? Similar to how a table's header row can be made to stay ...
0
votes
1answer
10 views

Move rows or columns with keyboard shortcuts in Numbers

Looking for a way to move rows and columns using the keyboard. This would obviously be based on the currently-selected cell — regardless of whether or not the row or column is selected. On a related ...
1
vote
1answer
20 views

Numbers: conditional highlighting using color scales?

Is this possible, like you can in other spreadsheet software to do something like this? (color scales)
1
vote
1answer
10 views

Numbers version 5.3(5989). How to Calculate Duration by comparing two cells formatted as datetime?

Column A has been formatted in the “datetime” format. Date and time from my glucose meter were entered into Column A and displays as in the default option I selected. Column D is the glucose readings ...
1
vote
1answer
15 views

Unmerge all cells in Numbers xls file

In this situation I have 2 cells merged into 1. How can I unmerge it so the result will be 2 cells with the same data? I have cases with up to 7 cells merged in the xls file. How can I unmerge them ...
0
votes
0answers
16 views

How can I set a file password for a Numbers file with AppleScript?

Is it possible to activate the password protection (that is available in the file menu, like described here) of a Numbers file via AppleScript? And if yes, how? As an alternative: could this be done ...
0
votes
1answer
26 views

Numbers help me work out my gas consumption

Trying hard to work out my yearly gas and electricity consumption. I have forumla for SUMIF: =SUMIF (B,"="&F6,Gas Reading) But I think I want to do (IF the year is 2015 [F6 entry], then find ...
0
votes
0answers
10 views

Not able to add column in Numbers

I created a table in Numbers. Please see below picture. Strangely, I am not able to add/insert column. As you can see, Add Column Before & Add Column After options are greyed out. Could someone ...
2
votes
1answer
89 views

Prevent Safari from transforming downloaded CSV files to Numbers files

On a computer that has Numbers installed, downloading a CSV file will automatically be converted to a Numbers spreadsheet and no longer be a plain CSV (not just the extension, but the contents ...
0
votes
0answers
31 views

Conditional Formatting for Numbers forms in iOS

I've been tasked with setting up a data entry form in Numbers on an iPad where cells in the sheet have conditional formatting, but it is desired to have the same formatting applied to the linked form. ...
1
vote
1answer
28 views

Naming a Cell in Numbers

Can you define a cell's name in Numbers for use in formulas across a workbook like you can in Excel?
0
votes
0answers
6 views

Keep Sheet Formatting In New Sheets On Numbers

I've created a template in Numbers that has the precise font and paragraph styles that I want. However, when I click the new sheet button, the next sheet reverts back to the original default font. Is ...
0
votes
1answer
26 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
11 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
10 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
18 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
87 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
20 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
5 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
10 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
17 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
8 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
28 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
18 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
25 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
186 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
22 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
290 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
81 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
45 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
24 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
8 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
23 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
103 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
30 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
79 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 ...