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.

3
votes
2answers
22 views

Apple Numbers, matching string variations in a SUMIFS function

I'm using a SUMIFS function to get values from a column in another table depending on if they have a certain string in a corresponding memo column. I'd like to be able to check for a few variations on ...
0
votes
0answers
18 views

MacOs Numbers Areas function?

Does anyone have a real-world use for the areas function? AREAS((B2:B3,C4:C5,D6:D7)) produces 3, the number of elements in the list but what now? Index takes an optional areas-index argument but it'...
3
votes
2answers
60 views

MacOs Numbers and tricks with braces

Has anybody played around with using braces in a formula? Syntactically, they seem to define collections inline in a formula. It would be great if we could figure out how to define multi-row ...
3
votes
1answer
49 views

How to Sum text values like numbers in Numbers?

How can I translate text values into numbers and sum the result?
3
votes
1answer
36 views

Creating a search engine within Numbers on a Mac

I want to know if it’s possible to create a search box directly within my Numbers document without the use of scripting, automator or terminal. The idea is that users could enter search terms in the ...
1
vote
0answers
8 views

MacOS Numbers Create Lists based on Category

I'm reasonably new at Numbers, so looking for some guidance for a problem I believe should be solvable. I've created a spreadsheet which includes a list of athletes and their corresponding brand ...
0
votes
0answers
27 views

Identify last (or first) non-blank cell in range

Is there a way to identify the last (or first) non-blank cell in a range? Consider a sheet that may have multiple rows with blank cells in a certain column. In a cell, I'd like to use the value of ...
-1
votes
1answer
42 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 ...
2
votes
1answer
18 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 ...
1
vote
1answer
26 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
1answer
25 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 ...
2
votes
1answer
72 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
30 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
12 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
31 views

Numbers app: 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
14 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
17 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
17 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
28 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
157 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
39 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
31 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
7 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
28 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
14 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
20 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
126 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
23 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?
0
votes
0answers
19 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
9 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
29 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
19 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
27 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
319 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
25 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
342 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
118 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
48 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
27 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
9 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 ...