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.

Filter by
Sorted by
Tagged with
3
votes
1answer
31 views

Numbers: menu or list to jump to a specific sheet?

Is there a way to access a menu or list of all the sheets in a Numbers document, so I can quickly jump to one specific sheet without having to scroll or page one-by-one with the previous/next keyboard ...
1
vote
1answer
63 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
1answer
37 views

Help with AppleScript to automate Numbers Cell Formatting

I do several mundane repetitive tasks using Numbers App on a Mac, and wish I could just automate the same with the help of AppleScript. I got Numbers Spreadsheet with several tables, on the selected ...
3
votes
4answers
19k views

Auto-Populate A Pop-Up Menu in Numbers 3.5

I'm trying to steer clear of Excel, despite my sister's nagging, and I've done pretty well to create a Quote and Invoice workbook in Numbers. The problem I am having is working out how to ...
0
votes
1answer
13 views

How do I establish a secondary axis in Numbers on an iPad Pro?

I see various older questions and replies about secondary axes and presumably can make them on my MacBook Pro. But I’m often working outside on my iPad these days and its lack of anything like ...
1
vote
1answer
19 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
1answer
54 views

How do I combine two text values from different cells to equal another cell?

Let’s say I always know my row will be 14. I only know the column by another value above it. For example, $Q$7 = A I want to be able to take that value A and add it so that my formula is now $A$14. ...
2
votes
2answers
1k views

iWork Numbers evaluate string

I have a cell with the following content 2262/4121. I want to have a cell next to it that contains the result of that expression. Is there a function for that?
2
votes
0answers
21 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 ...
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
14 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 ...
2
votes
1answer
50 views

How to interact with a Numbers sheet via AppleScript?

This question is related to: SUMIFS with comparisons to relative cells where I'm trying to figure out a way to do what I want using AppleScript. I've been searching the Web to find a way to set ...
0
votes
0answers
27 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 ...
3
votes
2answers
47 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
21 views

Unique values for x-axis in a number chart

I have a numbers table with a bunch of values in a column, and a count of the respective value in another column. If I am plotting this in a chart, how can I make sure that the values in the one of ...
0
votes
1answer
12 views

Generate a new table entry in one sheet from another

I have a numbers file with 2 sheets: sheet1 and sheet2. On sheet1 is where I am entering some data in some cells. On sheet2 there is a transactions table with different entries. Is it possible to ...
3
votes
1answer
37 views

In Numbers, how can I get a cell value from another sheet with a formula?

My need is to compare content cells from two different sheets in the same file and get the cell value from another column of the first one. This is the tested formula to find the right position: ...
4
votes
0answers
30 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 ...
0
votes
0answers
14 views

Is there a way to get more than 5 frozen footer rows in Numbers?

There seems to be an arbitrary limit of 5 frozen footer rows. I'd like to have 10 or 20, because I like to do a lot of analysis on the figures, have them in the same table, and follow the columns as I ...
1
vote
1answer
28 views

How to set Inspector in Numbers for macOS hidden by default?

Whenever I open a spreadsheet in Numbers for macOS, the Inspector's Format tab opens up. I'd prefer to have it hidden by default. Is there any way to change this behaviour?
0
votes
1answer
17 views

Adding column to multiple identically formatted tables in Numbers

I have a document in Number that contains many tables with the same format/columns but different content. I'd like to modify the format for all, adding a new, empty column in the same place with the ...
15
votes
3answers
14k views

Keyboard shortcut to delete row in Numbers

I can add rows conveniently using Option+Shift+Up Arrow (insert above) or Option+Shift+Down Arrow(insert below). Is there a keyboard shortcut to delete the current row?
5
votes
1answer
364 views

How to find in one sheet in Numbers?

When I try to search something in Numbers, it will find in all sheets. Is it possible to search in currently selected sheet only? MacBook Air macOS Sierra 10.12.3, Numbers 4.0.5
0
votes
1answer
18 views

Is is possible to multiply ranges and the sum over the new range in pages?

I want to multiply the price times quantity and summ it up. Obviously multiplying columns is not valid. I know i could make a second column where the "price X quantity" is represented and then summ it ...
0
votes
1answer
30 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
2answers
35 views

Is it possible to export a simple Numbers spreadsheet while being dynamic?

I have a few Numbers Spreadsheet that I use to keep track of my budget over the weeks/months but its only accessible in Numbers, which is fine Until I am at work where we use windows. My only ...
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 ...
-2
votes
2answers
43 views

Can't find recently edited numbers file nor the folder the file was in

I have an iMac running High Sierra. I created a spreadsheet in Numbers a couple of months ago. I have been updating it a few times each week. Last edit was this month a couple of times. The Numbers ...
1
vote
0answers
21 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 ...
0
votes
1answer
26 views

Collaborative spreadsheet application

I'm looking for an application that will allow me to create fields that represent 'points' to keep tally on mod actions by my online community. Another mod or user who i give permissions to can update ...
12
votes
9answers
41k views

How to gracefully import CSV files into Numbers.app v3?

I have a process, which has worked faithfully for years in Numbers '09, whereby I download my Bank account data in CSV format, then drag that data directly into my Numbers sheet (after creating an ...
0
votes
0answers
16 views

Find the starting row of a sequence of values inside a column of more values

The formula that I am trying to write in cell C1 will look for the first (or all, if multiple matches) starting row number of any given sequence of any number of row values written in column A amongst ...
1
vote
1answer
34 views

Change date format for column of existing non-US format datetimes in Numbers

I can't believe I have to ask this, but here I am. I have a Numbers (Numbers version 6.0 (6194)) sheet with data from an imported CSV file. One column is date/time info, formatted like so: 21.05....
1
vote
0answers
19 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?
3
votes
2answers
70 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 ...
0
votes
1answer
29 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
20 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
1answer
57 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
44 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 ...
0
votes
1answer
40 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/...
2
votes
1answer
77 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. ...
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
1answer
126 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
votes
1answer
51 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 ...
0
votes
0answers
37 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 ...
9
votes
3answers
19k views

How to fill down in Numbers without dragging?

I have a 20,000 line spreadsheet in Apple Numbers, and I need to fill a column with data. I don't want to sit there dragging down the fill handle for thousands of rows. How can I fill the whole ...
1
vote
4answers
8k views

Set Print Range in Numbers.app

Is there any way to set a print range in Apple Numbers.app spreadsheets, to print just a subset of cells rather than entire document?
3
votes
1answer
24 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 ...
1
vote
1answer
40 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 ...
2
votes
1answer
24 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 ...