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
2answers
1k 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
94 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?
0
votes
2answers
466 views

Using last column in Numbers

I would like to subtract the last column of a specific row. Since the number of columns is always changing, I need to get it dynamically. I figured there is a function that gives you the number of ...
0
votes
0answers
232 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
2answers
477 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 ...
2
votes
3answers
30k views

How to import a spreadsheet into Numbers from an email attachment?

I want to know how to open a spreadheet email attachement in the Numbers app on the iPad. Here are the steps I have taken with no luck: On the iPad I open my email. I see a spreadsheet attachment. I ...
0
votes
1answer
206 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 ...
2
votes
1answer
1k views

Split a column in Numbers by extracting text in parenthesis

I need to extract everything from "ORIGINAL COMBINED" that is between parenthesis and place it in the SPLIT A and place the remainder in the SPLIT B column. For example:
1
vote
1answer
2k views

Concatenate & VLOOKUP

In Numbers, I'm trying to enhance a Concatenated formula of multiple VLOOKUP results. I'm currently producing a result of three concatenated answers (each a specific VLOOKUP formula). I would like to ...
0
votes
0answers
27 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
51 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 ...
0
votes
2answers
6k views

Apple Numbers: how to change a date format to a number format

In Apple Numbers the app can work out the number of days between dates, but then if I times this by a number (ie, a %interest rate and an amount of money) Numbers insists that the answer is a number ...
1
vote
1answer
483 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-...
6
votes
2answers
120 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 ...
1
vote
0answers
40 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
58 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
175 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 ...
0
votes
1answer
27 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 ...
6
votes
2answers
3k 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
112 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| |...
0
votes
1answer
7k views

How do I plot two data streams in Numbers as a graph?

I have two different streams of fractional values I want to visualize using Numbers for Mac. They both have one value per line and both look would look something like this (with different values ...
1
vote
1answer
2k views

Is there a way to put images in cells in tables in iOS Numbers? 3.2

Is there a way to put images in cells in tables in Numbers iOS version 3.2? I've looked at the Apple help and it only shows help for on the Mac and putting an image for a cell background. I'm using ...
1
vote
1answer
311 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
773 views

Numbers Lookup Finding incorrect values

I have many tables with two columns (key-value style) and I want to combine all the values in a single table. I lookup key in a first column and insert a value from the second one. I've encountered an ...
3
votes
0answers
863 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 ...
0
votes
1answer
7k views

How to see page breaks in Numbers version 3.x

In my old version of Numbers, I could see the page break (both at the bottom of the page, and on the side) so I would know when I needed to add a row or column. I can't seem to be able to see the page ...
4
votes
1answer
17k views

How to change cell background color in numbers according to some rules?

Making it simple, using Numbers, how can you set up the following: If number is positive make background cell green, else make it red.
2
votes
1answer
726 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 ...
3
votes
1answer
5k 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
357 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
520 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
143 views

“Glitched” pixels, El Capitan, formula box in numbers

Today I installed El Capitan on my Macbook Pro and noticed some weird graphical effects when I was editing my numbers document: I know that this is entirely software-related, otherwise the screen ...
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.
6
votes
1answer
14k views

Locking cells in numbers

Is there an easy way to lock individual cells or a group of cells in Numbers to prevent the data in the cell from being changed?
0
votes
1answer
140 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 ...
1
vote
1answer
602 views

Will Excel formulas be OK if they are imported within a spreadsheet into iPad Numbers?

Will Excel formulas be OK if they are imported within a spreadsheet into iPad Numbers?
4
votes
1answer
1k 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
667 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 ...
1
vote
2answers
3k views

How to hide columns

The old version of numbers had a "hide column or row" feature. I could right click a column and the "hide" option appeared on the same window as "add/delete" and "merge." However with the 3.2 update I ...
1
vote
4answers
8k views

How do I delete one of my custom templates in Numbers - OS 10.10.1

I would like to delete one of my custom templates I made in Numbers - in previous OS versions you went to Library>iWork>Numbers>Templates and just trash it - but, since I updated to Yosemite - I only ...
4
votes
2answers
4k views

Concatenate not working in Numbers

Sample numbers file B4 contains CONCATENATE(B2,B3) In the file above, I am getting syntax error on B4, despite the formula seems correct. Can anyone reproduce the problem? How can I solve it? ...
1
vote
1answer
152 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
100 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 ...
1
vote
2answers
63 views

Text in cell with URL hidden

I'm trying to copy and paste a number (tracking number) from a UPS notification into a cell on Numbers. I want the number to appear with the link hidden but it keeps pasting the entire URL in the ...
2
votes
1answer
44 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 ...
0
votes
1answer
1k views

Link tables for auto new rows - Numbers

Is there a way I can "link" tables in Numbers so that when rows are added to the "master" table that the identical rows and containing data are added in a linked table? I know I can "link" cells using ...
1
vote
1answer
74 views

Numbers: Line graphs for cell values across multiple worksheets

I want to create a line graph whose reference data is across multiple worksheets. For example: I have 5 different worksheets (named W1 to W5) In each of the worksheet, a specific cell (Ex: B2) in a ...
1
vote
1answer
4k views

In Numbers, is there a way to get the row instead of the value when using a MAX or MIN Function?

In Numbers, is there a way to get the row instead of the value when using a MAX or MIN Function? For example, let's take this sheet: bread 10 cheese 20 meat 35 What I am trying to do is to show ...
3
votes
2answers
1k views

Conditional highlighting of booleans in Apple Numbers

Is it possible to do conditional highlighting of booleans in Apple Numbers? I want to highlight TRUE values one way, and FALSE values another, but booleans don't seem to be supported - only numbers, ...
2
votes
1answer
39 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 3 4 5 6 7 11