Questions tagged [numbers]

Apple Numbers is an application for creating spreadsheets and graphs. Use this tag for all versions of this app, web based, iPad and iPhone as well as macOS

78 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
32 views

Transpose a colum into a line inside the same table using a keyboard and trackpad combination

Given the data on this table I type the formula "=B2" in cell "D2" and get Now, I want to select cell "D2" and somehow get the formulas "=B3" in "E2", "=B4" in "F2", and so on, thus resulting in ...
4
votes
0answers
1k views

How to get the current sheet name into the cell in Numbers.app

Scenario: Have a spreadsheet (Numbers.app v3.6.2/El Capitan) it contains multiple Sheets (every sheet contains multiple tables, but this doesn't matter) Every sheet is renamed to some defined name, ...
4
votes
0answers
3k views

How to use an array as a condition in a COUNTIFS or SUMIFS formula

This question could be tricky to follow so I'll split it out with examples Given I have this table of overpriced fruits; Item Price Apple £0.80 Peach £1 Pear £1 ...
4
votes
0answers
3k views

How do I create a Pivot Table in Numbers 3.2?

I'm new to Numbers and currently using Numbers 3.2. I already have an idea of how to use SUMIFS to create Pivot Tables in Numbers, but I'm still looking for a better way to generate the column & ...
3
votes
0answers
120 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 ...
3
votes
0answers
957 views

AppleScript and Numbers: Copying from one spreadsheet to another?

I'm new to AppleScript, and I'm trying to find a way to use it to copy a value from one Numbers spreadsheet and paste it into another file. The situation is that I've been using Numbers to run a ...
3
votes
0answers
60 views

Altering behavior of Option + arrow keys in Numbers for Mac

In Numbers, pressing ⌥ (option)+→ (or with any other arrow key) will add a row or column in that direction, relative to the currently selected cell. This is a useful shortcut which I employ frequently,...
3
votes
0answers
453 views

Changing the open with settings in 10.10.1

I am looking for a way to edit the open with settings in 10.10.1, i have looked through older questions and have attempted to rename the launch services plist and have gotten no where. I have looked ...
3
votes
0answers
1k views

What is the Numbers keyboard shortcut to get in the formula bar of a cell?

I am looking for a keyboard shortcut in Numbers to edit the current cell via the formula bar (if that is the right word). Screen shot: Please note, I am not looking for this answer. That is how to ...
2
votes
0answers
55 views

What's going on with Apple Numbers dates?

I have an Apple Numbers table that I've been updating since 2016. At the start, I incorrectly inputted dates such as 1-1-2009 as 1-1-9. (This is not a problem for later dates such as 1-1-10 because ...
2
votes
0answers
104 views

Select all next non-empty cells in Numbers

Is there a way to select all next non-empty cells? as in pressing Shift+Ctrl+Arrow Key in Excel app For example, I'm now at A1 and A5 is empty. ▼ By what means I can select A1 to A4 by one key ...
2
votes
0answers
52 views

SUMIFS with comparisons to relative cells

(This is somewhat similar to How do I reference a cell from within a "...IF"-type function condition string? and SUMIF statement with two different conditions (Text based and checkbox)) I ...
2
votes
0answers
32 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 ...
2
votes
0answers
25 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
0answers
2k views

How to find duplicates in Numbers?

I have a list of conference attendees, and I want to make sure the emails are unique. I could use a countif statement and then sort and delete but looking for other ways and ideas.
2
votes
0answers
129 views

How to dynamically create or populate a table from a masterlist in another sheet?

I have a table with 500+ rows in Sheet 1 (let's call this "masterlist". In another sheet, I'd like to be able use a drop-down cell containing certain key values (all taken from a single column in ...
2
votes
0answers
66 views

Is it possible to reference a cell in Numbers using two column headers?

I am aware that I can reference cells using the name of row/column headers. It looks something like this: Sheet Name::Table Name::Column Name Row Name. However, I'm trying to reference something ...
2
votes
0answers
308 views

Using date as x-axis

I wish to create a chart where you can compare how many awards a bunch companies have won over time. After collecting the data I now want to plot it in Numbers. To simplify I have put together some ...
2
votes
0answers
493 views

Apple Numbers Query - Conditional Formatting

I am working on a numbers Spreadsheet that compares dates in cells. I am trying to create a condition where a date cell will turn green when the date is 3 months or more later than another date cell i....
2
votes
0answers
2k views

Adding standard deviation (custom) as error bar in Numbers v3.5.3

Qn similar to How can I add custom error bars to a graph in Numbers. I'm not able to modify and/or customize error bars even after clicking on the graphical error bars for each series as mentioned in ...
2
votes
0answers
61 views

Looking for a grandma-safe way to create two-fold greeting cards

My Mom (+ 70) longs for the day when her Windows Paint Shop program would walk her through creating a 2-fold 8 1/2 x 11 card. She could assemble the card one page at a time and not think about what ...
2
votes
0answers
642 views

batch convert iWork 08 files to new version on Yosemite

TL;DR Short version: I have a bunch of files that were created with iWork 08. Is there a way, maybe using AppleScript or Automator, to convert them to the new format (Pages 5.5, Numbers 3.5) without ...
2
votes
0answers
581 views

How to display labels on bubble chart, Numbers (v3.2)

I want to display the label of each bubble on a bubble chart in numbers. How do you do this? I want either a truncated "description" or the 3-digit NAICS to be the label of the bubble. Here's an ...
2
votes
0answers
146 views

Is there a way to have a formula in numbers 09 return an empty value (ie isempty() returns true?)

I've got a list of times and ages, and want to extract ages for a particular range of time values. So I've used an 'if' formula to copy the age for an entry if its time is between two values. The ...
1
vote
1answer
11 views

Linking between tables in different spreadsheets in Numbers

I wonder if it's possible to link tables from different spreadsheets. I have several live projects running at the same time, for each I have a "Project finance" sheet, in which I have ...
1
vote
2answers
40 views

Capture month end values in Apple Numbers

Is there a way to capture a cell value at a specified time in Numbers. For example if you have a stock portfolio and wish to capture month end values can this be done?
1
vote
0answers
20 views

Numbers removes Byte-Order-Mask (BOM) from UTF-8 files when exported as CSV. How to fix?

I am dealing with a requirement where CSV should be UTF-8 encoded, in order to detect this in my java application I am relying on Byte Order Masks which is working perfectly fine but we found out that ...
1
vote
0answers
38 views

Get historical currency rate via CURRENCYH shows error: The requested historical date is invalid or is in the future

From Apple Number’s doc, the formula CURRENCYH should return historical currency data. Examples =CURRENCYH(“USD”, “GBP”, 3, “18/04/2017”) returns £0.78, the lowest rate of exchange (“low” or 3)...
1
vote
0answers
20 views

CSV import works in Numbers, but fails in Mac Excel and Mac OpenOffice Calc

If I open a CSV file in Numbers, a particularly long series of text-only cells works like a charm. If I open the same CSV file in Microsoft Excel for Mac, or OpenOffice Calc for Mac, the long cells ...
1
vote
0answers
54 views

Help with Apple Script for dealing with duplicates in Numbers

I had a script that I used to find duplicates in a numbers document and to highlight the duplicate in red. Well I now have a file where there are multiples of the descriptor in column B that are ...
1
vote
0answers
22 views

Is it possible to remove versions from Numbers

I tried importing a large Excel spreadsheet to Numbers. It became even larger, and some features do not work. I decided to delete some sheets (containing graphs which don't work, and are effectively ...
1
vote
0answers
182 views

How to completely turn off auto-format and copying format in Apple Numbers

I want to completely disable auto-format and copying format on Copy/Paste. Is there a way to do it?
1
vote
0answers
50 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
46 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 ...
1
vote
0answers
15 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
43 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
vote
0answers
13 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 ...
1
vote
0answers
42 views

two tables, one chart (x-axis is time)

I have two tables such as Var_A Var_B 5. Jan 2017 33.3 2.22 5. Jun 2017 44.44 3.33 Var_A Var_B 5. Feb 2016 22.2 5.55 5. Jul 2016 27.2 4.44 and I would like to ...
1
vote
0answers
366 views

Calculate number of Tuesdays (for example) between two dates in Apple Numbers

I am attempting to calculate the quantity of a given weekday (say, how many Tuesdays, or Thursdays, etc.) between two dates. I'm running afoul of what seem to be Numbers' limitations as compared to ...
1
vote
0answers
55 views

Numbers formula for calculating *part-time* workdays per month?

I want to calculate the total number of monthly workdays for part-timers. Example, I need to calculate the full number of workdays in a month for a 3.5 day workweek, running from Tuesday to half ...
1
vote
0answers
1k views

The font Calibri is missing. Your text might look different with Pages, Numbers

My documents do not contain that font anywhere. But the iPad still complains about this. How can I remove completely these font from document? Is there a way to do this? Maybe there are special ...
1
vote
0answers
43 views

In Numbers.app, Is there any function to identify if another cell is a formula, or contains a specific function?

I have a cell in a row that is either a directly entered number, or a SUM() of some other cells. Is there any function I can use in a different cell to know if the value in the former cell was ...
1
vote
0answers
1k views

how to conditionally ignore cell when applying sumproduct using Numbers (Mac)

Under Excel, there's something like = Sumproduct((A1:A100),--(A1:A100<>"")) from Excel formula -> how to change SUMPRODUCT formula to skip null cells But it did not work for Numbers. Wondering if ...
1
vote
0answers
79 views

Can't use any of the iWork apps

I'm unable to use any of the apps included in the iWork package. If I try to open any one of them, the app opens but I can't perform any action. I click on the bar menu items to see that even 'About ...
0
votes
0answers
13 views

How do I record changes to a cell in Numbers via AppleScript?

I'm very new to AppleScript so bear with me. What I am trying to achieve is for every time I run the script, the current value of a cell is copied into a cell, one column to the right of when I last ...
0
votes
0answers
5 views

Pages: Long table pasted into page-layout document is truncated

I'm pasting a long table (created in Numbers) into a page layout document in Pages 8.2. The results look sort of like this (sorry for blurring out the text): I have not been able to make the table ...
0
votes
0answers
6 views

In Numbers, show data (rounding) with a given number significant figures?

In Numbers, show data (rounding) with a given number significant figures (sigfig)? Either purely visually (like it's format setting for decimal plages (dp)), or any other way, without changing the ...
0
votes
1answer
17 views

Is there a way to restore the original sorting in a Numbers table?

I have just started using Numbers and I started messing around with the organization options. Filters and categories work great, however, sorting has a weird behaviour. If I sort the rows by a given ...
0
votes
1answer
11 views

How to empty a cell in Numbers without formatting the cell

How do i delete all the content from a Numbers sheet without formatting the cell? Using google it says to use the delete button however it does empty all the functions and format as well. I have my ...
0
votes
0answers
16 views

Formula result does not display in Numbers for Mac - Intermittent

[Note: this is not the same issue as the post entitled "Display Blank on Formula Error" so please don't mark this as duplicate for that reason.] Some cells containing formulae are not displaying, but ...