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.

73 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
695 views

Numbers shortcut to select next non-empty cell

I have just purchased my first Mac and am having problems with Numbers. I want to select the next cell in a given direction that is non-empty (or jump to the end of a contiguous chunk of cells that ...
4
votes
0answers
29 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
2k 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
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 ...
3
votes
0answers
700 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
57 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
19 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
20 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 ...
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 ...
2
votes
0answers
19 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
112 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
61 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
889 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, ...
2
votes
0answers
229 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
439 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
57 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
638 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
560 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
143 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
13 views

Numbers - continuous line connecting gapped data?

This question over on SuperUser is exactly the same as mine, in the sense that I have a CSV that contains gaps in each column, but I want to plot it as a continuous line. However, I'm using Numbers, ...
1
vote
0answers
27 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
13 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
15 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 ...
1
vote
0answers
14 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
6 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
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 | |------------|------------|-------...
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, ...
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 ...
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 ...
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
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 ...
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 ...
1
vote
0answers
35 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
1k 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.
1
vote
0answers
303 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
54 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
37 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
546 views

How to export a table with transparency from Numbers to PNG?

If I copy a table from Numbers to the pasteboard and then create a new document in Preview, it usually works fine, but if cells contain partially transparent background or border colors (especially ...
1
vote
0answers
908 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
7 views

How do I choose the minimum value from a lookup table?

I have a Numbers spreadsheet that I use to track my investments. One table includes each stock purchase (ticker, entry basis, entry date, number of shares, computed cost/share. I want to select the ...
0
votes
0answers
12 views

Conditional stdev function in Numbers?

If I have a set A of numbers in Numbers (hah), I can use averageifs to calculate the average of the subset of A which satisfies certain conditions. For example: Say I have the following table: If I ...
0
votes
0answers
25 views

how do I copy a table in Numbers 6.0 without losing the formulas?

Im using the newest version of numbers 6.0 and I'm looking for help on duplicating spreadsheets...I'm working on a custom monthly P&L and want to make a new one each month but do not want to lose ...