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
0
votes
1answer
109 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
849 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
494 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
117 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
60 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
62 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
43 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
72 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
37 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
855 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
48 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?
0
votes
1answer
71 views

Is it possible to add an HTML Snippet to Numbers on OS X?

Is it possible to add an HTML Snippet to Numbers on OS X? I would like to add some html code and have Numbers treat it as such, for example to use iframes embed websites into my document. Would this ...
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 ...
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
96 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
763 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
514 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
2answers
138 views

How to stop Numbers from beeping at me when I use the arrow keys?

When I edit spreadsheets in Numbers, I often hold down the left or right arrow key to get to the far-left or far-right column of a table. Numbers always beeps at me when I do this. It seems to think ...
1
vote
1answer
2k views

Can Numbers create stacked column charts with two columns for each category?

I'm trying to create a column chart in Numbers where each column is also stacked. For example, consider the following data. Here we have numbers for the total sample and numbers for how that total is ...
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 ...
5
votes
1answer
77 views

How can I change a Numbers graph x axis to go from the lowest value to the highest value?

I'm graphing columns A and B, where A is the x axis. I have entries entered in A like so: 1, 3, 2, 4, 5... and so on. When I select A and B and make a graph, it seems like the x axis does not ...
1
vote
1answer
191 views

Mac Numbers - how to copy multiline text without quotes

When I copy a cell that has multiline content, and paste elsewhere, Numbers puts quotes around it. How do I paste without quotes, I want to paste multiple line, as it is seen in the cell.
0
votes
1answer
822 views

Numbers giving a `can’t be used as a single value` error

I have a table of data, I am using the following formula =ROUNDUP(Salary::Table 1::G2:BC5/6,0) Error : The range Salary::Table 1::G2:BC5 can’t be used as a single value. What am I missing ?
4
votes
3answers
21k views

Insert date & time in latest version of Numbers

I've looked around online and have found references to an "Insert => Date & Time" capability in Numbers for OSX. But it's not there in my version of Numbers (3.0.1 -- 1483). Has this capability ...
2
votes
1answer
236 views

Apps for (very!) simple spreadsheet purposes

Is there any way to do simple offline spreadsheets (rows, columns, plus, minus, multiply, divide, sum of range) like below without using monsters like Excel, Numbers, Google, Open Office, etc.? I ...
1
vote
1answer
2k views

Is there a way to create a polar plot in Numbers?

I am trying to do a polar plot, or radar chart as excel calls them, for a report. I don't have excel, only Numbers, is there a way to do that type of plot with Numbers? I can't seem to find a way. The ...
2
votes
6answers
4k views

macOS/OS X Numbers 3.2 inserting date / time

I want a cell to take on the date and time of "this moment", and then leave it. Contrary to some experiences I've read about, the Insert menu does have Date & Time, but it doesn't seem to respect ...
0
votes
1answer
100 views

Highlight parts of a 2D Line Chart in Numbers

I'm using the latest version of Numbers (4.2) and am looking to plot a Line Graph, with a few sections highlighted in a color as shown: Any leads on how to do the same?
1
vote
1answer
30 views

Numbers : Conditional Highlighting with decimal

I have a cell, the value is 90.90, I setup a continual highlighting for different value, one is suppose to be greater than or equal to 99.90. however I don't get this one to work as 99.90 is ...
3
votes
1answer
1k views

How do I get a log-log plot in Numbers

I can't seem to find a way to create a log-log plot in Numbers 4.2, something that should be as easy as clicking twice! The option is only available for the Y-axis:
0
votes
1answer
48 views

Counter formula that subtracts with each transaction

This must exist, but I can not figure it out with Numbers. I have an inventory of products I sell. I want to automatically subtract from the total original inventory each time an item sells. And to do ...
1
vote
1answer
36 views

Sum an entire column in Numbers from a different sheet?

Is there a way to do something like Sheet1::Table1::SUM(A1:AΩ), where Ω returns the last row number on Sheet1? This would enable leaving Sheet1 with values only, no formulas.
2
votes
1answer
114 views

Calculate sum of true/false checkbox cells

I can add true/false buttons ok. I wish to have these buttons equal a number when it's ticked then be added to a total. I'm brand new to numbers but finding my way ok so far. I do team sheets. Each ...
0
votes
1answer
2k views

Mastering Categories in Numbers

I have a budget with a Column for "Categories" and for "Amount". Within the Column for categories, as one might expect, is a category for "Groceries". Groceries is column "C" and Amount is column D. ...
3
votes
1answer
917 views

How can I abort a calculation that is hanging in Numbers for Mac?

I rather stupidly wrote a formula that has caused Numbers to get stuck showing the message "calculating...". I've waited over an hour and it's still not completed. I've also tried force Quitting, but ...
12
votes
1answer
2k views

How do I combine separate cells in a Numbers spreadsheet and paste the result as text into a TextEdit document?

I have a Numbers spreadsheet. Column B contains first names, column C contains surnames. I need an easy way to combine and reformat this data so that it’s in the format Surname, Firstname. I then ...
-1
votes
1answer
4k views

Creating an adding and subtracting formula in Numbers

I'm creating a financial spreadsheet and need to ask the spreadsheet to calculate the new balance after subtracting and adding sums. For example, I want to calculate the running total in E column. I ...
3
votes
2answers
80 views

macOS numbers formula range problem

I can't seem to find the equivalent of: H2:2 In macOS Numbers app. This statement in a formula tells that the formula should take the cells from H2 to the end of the row into consideration. I can't ...
3
votes
1answer
9k views

Lookup up cell values in Numbers

I want to build a simple word translator which may look like this: COLUMN A: I have a list of words, each on a row. (1:Airplane, 2:Car, 3:Cat, 4:Dog etc..) COLUMN B: I have a list of the same words ...
3
votes
1answer
1k views

How can I export a Numbers 3.x chart to PDF?

I created a chart in Numbers 3 (version 3.6.2). In earlier versions of Numbers I could copy the chart and paste it into, e.g., Adobe Illustrator as a PDF vectorgraphic. In 3.6.2, copy and paste ...
8
votes
3answers
39k views

How can I use a secondary axis in Numbers?

One of my main problems with Numbers is the fact that it has much less of the functionality of Excel. That's why I barely use Numbers. One of the main things that I always thought impossible was ...
1
vote
1answer
3k views

Numbers How to show a hidden column?

First time working with Numbers and I hid a column by mistake. How do I show/unhide a column in this application?
0
votes
1answer
780 views

Apple Numbers '08: extending a formula

How can I get a formula to apply to every cell in a column? (i.e., I want to subtract a number I just entered in one cell from a total I have in a previous cell and I want to do it each subsequent ...