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
2
votes
1answer
17 views

Increase numbers by one in merged cells

My question is very related to this https://discussions.apple.com/thread/3204532. I just want to do the same but in merged cells, as in the picture below. Is it possible? I see no fill handle here.
2
votes
1answer
563 views

Unable to open CSV file

I have a reasonably sized CSV file (40 Megabytes). I know that some apps won't work with certain encodings, and that they will throw error if the encoding isn't ASCII. But its alarming that even ...
0
votes
1answer
26 views

Information on Box

updates for Numbers, Pages, and Keynote say that you can do collaborative work using Box. What do we know about this "Box"? Searching such a short word on Apple's site seems hopeless.
2
votes
1answer
33 views

Shortcut to Bottom border in Numbers

Here there are many shortcuts for Numbers https://support.apple.com/kb/PH23737?locale=en_US&viewlocale=en_US. I would like to have one for Borrom border. I tried (without success) the following: ...
0
votes
1answer
462 views

How to save changes in a CSV file using Mac Numbers?

I have a .CSV file, it opens well in Numbers ~4, but when i do changes in that file (editing row color, etc) i can't correctly save it. If i try to save it as .numbers - when i open that .numbers file,...
2
votes
1answer
50 views

Apple Numbers : countif and stats

I have a sheet with a few columns, Columns A contain dates, Columns T contain some text What function can I use to count : The numbers of result in the columns A which match the current day I ...
0
votes
2answers
142 views

AppleScript export variable to Numbers / Excel / SQL

I would like AppleScript to add a new row on a number or excel sheet (or on a SQL database) I have my data saved on a .plist which I can retrieve with set myDateFromPlist to value of property list ...
1
vote
2answers
3k views

Using formulas in conditional formatting in Apple Numbers

I'm using Apple Numbers in macOS, and utilizing its conditional formatting feature to compare some numbers, however I want to compare the numbers' absolute value. The numbers I work on are ...
0
votes
1answer
49 views

Create a table from other table depending on a value NUMBERS

I have a table with a list of items, and I want to create a new table with all the values that contains a certain value. In the first list, are all the profucts that I usually buy and a cell with "...
0
votes
0answers
202 views

iCloud Drive: My files can't be found on my iPad

I have 200go on my iCloudDrive and all my Documents folder is on the cloud. On my iPad, with the Files app, I am able to browse in the folder hierarchy in Documents but ultimately the folders are not ...
1
vote
1answer
48 views

Reference image in Numbers?

I have found that I can add images to cells as background in Numbers in various sheets. I'd like to reference these images in these cells from another sheet. Is this possible?
1
vote
2answers
353 views

Text substitution and change cell background colour. Numbers & AppleScript

I am working with Numbers spreadsheet files whose final output must be in German. The source of the data is the Apple Configurator app (via Automator), which produces everything in English despite the ...
0
votes
1answer
104 views

Open text file in Numbers when it is space delimited, but some fields are strings in quotes with spaces

I have a log file I'd like to open in Numbers to make sifting through it a lot easier. The problem is that the format isn't CSV. Each line has about a dozen fields, and the fields themselves are ...
0
votes
0answers
24 views

Import dates from Excel to Numbers?

I'm trying to move to Numbers instead of Excel for basic sheet stuff, as Excel is a pain in the ass to use on Mac. I'm trying to have some dates to look like dates and apply conditional formatting. ...
1
vote
2answers
38 views

Numbers if cell is equal to X or Y

Is it possible to test a cell using IF against multiple strings? So for example, I want the function to output Fruit in cell A2 if cell A1 contains the string Apple or Orange. I can only come up with ...
1
vote
1answer
140 views

How to convert a cell with a duration (datetime difference) to number in Numbers?

I have four fields in Numbers on macOS: F1: datetime F2: datetime F3: duration F4: number The dateime-fieds contain only a time, like: 10:00 11:00 11:00 12:30 13:00 13:15 The duration-...
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 ...
2
votes
1answer
57 views

entering data in Numbers

When I hit Return after entering a number in a cell, the cursor automatically drops down to the next row under the cell. How can I disable that, so it stays on the cell I entered and I can move on my ...
4
votes
1answer
90 views

Numbers fill color

In Numbers is there a way to set a fill color to repeatedly select for random cells, such as in Excel? I am not looking for a conditional formatting. I would like to color fill any cell I choose ...
4
votes
3answers
3k views

How to install old iWork on a MacBook with MacOS High Sierra?

I have a new MacBook Pro running High Sierra (10.13.2) and installed current versions of Pages and Numbers. But I need also the old versions (from iWork 9 I think) with mail merge support. I had those ...
6
votes
2answers
109 views

In Numbers can you auto-populate a cell with a date when another cell is populated?

I'm an avid Excel user and recently I've had to figure out how to use Numbers. So far I've been able to replicate all the Excel functionality that I use in Numbers... except for one thing. In Excel ...
0
votes
1answer
26 views

How to edit shared iCloud note in native app?

I shared an iCloud note with somebody else to work on it together. I sent a link via E-Mail which points to iCloud.com. The other person opens the link, signs into iCloud and then the note is opened ...
4
votes
2answers
2k views

SUMIF statement with two different conditions (Text based and checkbox)

How can I create a SUMIF statement with multiple criteria? I have a spreadsheets where I track hours for different clients in one table, and below this table I want to summarize in a summary table ...
2
votes
1answer
84 views

Calculating a custom total for a column on iPad mini and Numbers

How do I make a formula to total (sum) a column using Numbers on iOS, but exclude negative numbers? (Only sum positive numbers) Example: +-------+ | LIST | +-------+ | 1| | 2| | 3| |...
3
votes
0answers
694 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 ...
2
votes
2answers
816 views

Any way to use a VLOOKUP formula in Numbers to insert an image instead of text value?

The intent is to create a sheet that references orders from customers with an image of each item ordered from my catalog of inventory. I need to create a spreadsheet that references item SKUs to ...
1
vote
1answer
201 views

Numbers: Find a cell in a table (lookup) using multiple criteria

I'm using Numbers '09 (but can upgrade if need be). How can I find a value using multiple criteria? Let's say I have a table of flights, with columns for the flight date, flight number (including ...
3
votes
1answer
3k views

How to export only the selected part of my Numbers file to PDF?

I have a Numbers file which has a lot of elements that when I want to export it to PDF it becomes 12 pages of A4 size. All I want is selecting part of it and exporting only that part to PDF. Is it ...
3
votes
1answer
156 views

Count number of text occurrences in column using Numbers

I am using Numbers to track data. I have a column that has comma separated values within each row (e.g. ‘I like cats, I hate rain, I like dogs’). Is it possible to count the number of appearances for ...
1
vote
2answers
387 views

If reference cell contains “x”, return “y”, otherwise return “z”

I'm trying to build what seems like a dang simple formula, but for some reason it's stumping me. Here's the idea: IF(//B4 contains "apple"//),"$100","$200") so that it returns "$100" if B4 contains "...
2
votes
1answer
570 views

set checkbox based on parameters in iWork Numbers

I would like to be able to tick or untick a checkbox in iWork Numbers based on certain parameters. The spreadsheet is a list of projects (Column C), each composed of several tasks (column D). Column ...
1
vote
2answers
804 views

Numbers: How to prevent Numbers from changing currency automatically?

I have a spreadsheet that has cells with two currencies. USD & EUR. I have a cell that is a USD formatted cell. I now have a EUR cell that is based on a multiplication of the USD formatted cell ...
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.
0
votes
1answer
100 views

How to import data into numbers properly

So I have a file with data, see link below: http://www.epsilon-uitgaven.nl/bijlagen/E76/E76-tweelingdata.txt I'm trying to import this into numbers, but what I get is the following: Instead of ...
4
votes
1answer
788 views

Is it possible to swap two cells content in numbers?

I have a couple of rows and I have to move some cells from one row to another. Right now, I have to Copy/cut cell A1 Paste it in an auxiliary empty cell C1 then copy A2 paste it in A1 finally cut C1 ...
2
votes
1answer
466 views

How can I divide a range of cells by another range of cells and then sum them up

I have a table like this how can I do the same thing in Numbers like this the screenshot comes from excel, if I do the same thing in Numbers, I will get a complain like this:The range E3:E7 can’t be ...
2
votes
1answer
54 views

Windows Excel protected sheet opened in Numbers

Windows I have an Excel file whose all sheets are protected with password, and even the Excel file itself is password protected. In the Windows version of Excel, I have no issue with this, password ...
2
votes
1answer
40 views

Compare columns for highest value, and count result in another cell

I am looking for a formula which will compare the higher of two numbers in adjacent columns, and count the result of where in e.g. column B the value higher is than column C. It would be really ...
1
vote
1answer
113 views

Numbers Bubble Chart Bubble Radius

I can't figure out how to change the radii of the bubbles in a bubble chart in Numbers. I tried taking the original data and dividing it by 10, or 100, and redirecting the Size: data to the new column,...
2
votes
1answer
36 views

Adjust numbers (iWork app) formula to add if 2 cells are 0, leave blank

I need help adding another rule to my formula, I need it to also say IF U17 and X17 both have 0 in them, then leave blank Formula Y17 IF(OR(U17="",X17=""),"",IF(X17+V17=U17,"Push", IF(X17+V17>U17,W17,...
1
vote
1answer
797 views

Count cells with background color

In a range of cells, is there any way of counting the ones with certain background color?
0
votes
1answer
47 views

Numbers: Is it possible to import animated gifs?

I wanted to know if there is any chance to run an animated gif or somekind of video within a numbers table?
3
votes
1answer
4k views

Numbers: Creating a Summary table based on values from different table

I have a table that looks much like this: That Category column is entered manually and will have several duplicated values. I’d LOVE to be able to create a “Summary” table that manages to copy and ...
1
vote
2answers
56 views

Taking long list of repeated values and copying to sorted, unique list

Alrighty, I’m working on some homespun financial rejiggering. I have a manually-entered “Keyword” column that features many repeated values. A small sampling: Cleaners Cleaners Cleaners Cell Cell ...
2
votes
1answer
18k views

Get Numbers & Pages et al. on macOS 10.11 El Capitan

I have some old macs which cannot update to OSX 10.12, however this is the minimum requirement for installing those applications from the app store. Please could someone advise how to get an older, ...
1
vote
1answer
46 views

Save the order or a column

I have some words in column B. They are sorted by a personal criterion, nothing that Apple Numbers can consider: At a certain point, I want to organize the information by another criterion. For ...
4
votes
1answer
94 views

Correlative numbers formula in Apple Numbers

I have text in column B. But there are some columns that are empty. There is no rule the empty raws are at random. This is what I have now: I want to have correlative numbers in column A. The problem ...
0
votes
0answers
704 views

How to set a custom page size in Numbers?

There seems to be no option for this on Numbers 4.2 There are a bunch of options with fixed sizes, but nothing to set custom values for the document's width and height. The reason is that I want to ...
3
votes
1answer
485 views

Cut and delete a row in Apple Numbers in a single step

In Apple Numbers, I think that I cut the content and deleted a row at the simultaneously in a single step. I did that by accident, but then I could not reproduce it. I have been searching but I cannot ...
1
vote
1answer
24 views

NUMBERS: Lookup hourly rental rate based on date of transaction

I have a resource that has an hourly rental rate. That hourly rate has changed (increased) over time. To capture that rate history, I have created a table with the date of the rate change and the new ...