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
5
votes
1answer
72 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
185 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
783 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 ?
2
votes
1answer
219 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
68 views

How do I show the sum of multiple ranges in one cell?

How do I show the sum of multiple ranges in one cell? I want to add the sum of C5:C25 to the sum of G5:G25 and divide the answer by 14.
1
vote
1answer
582 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 ...
0
votes
1answer
94 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
29 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:
1
vote
1answer
35 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
104 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 ...
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 ...
3
votes
1answer
902 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 ...
2
votes
1answer
7k views

Numbers for OS X Yosemite 10.10.5

I need Numbers for OS X Yosemite. When I try to install from the Apple store, it only gives the option for 4.1. I think I need 3.2.2 or around there. When I try to install 4.1 it complains: I cannot ...
3
votes
2answers
79 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
8k 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 ...
0
votes
1answer
46 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 ...
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 ...
5
votes
2answers
3k views

Time as x-axis in chart with Apple Numbers

I'm trying to make an area chart in Apple Numbers (on Mac) where I have a series of values I want to plot on y-axis against time on the x-axis. Each value has a date that it occurred but the dates ...
3
votes
1answer
485 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 ...
7
votes
2answers
405 views

How do I get iWork / iMovie / Garage Band free of charge?

Everything that I have read says that iWorks/ iMovie etc should be free for Mac users after 1 September 2013. I already bought Pages but want Numbers and iMovie. My MacBook Pro with retina is early ...
2
votes
1answer
395 views

I am trying to “split text to column” on a .csv file in pages

I have one column that is asking for my customer's name, some of my customers put just one and others put several names (first, last, title, etc.) I am trying to change this column to split at the ...
2
votes
1answer
214 views

Numbers - Conditional Sum

How should I write the conditional SUMIF if I want to SUM values in column C where column B is IP?
1
vote
1answer
42 views

Convert dynamic content to static in Numbers

I have used some formulas in Numbers and I would like to change the dynamic values to static ones, so I can copy them to different sheets, without having any reference errors. Does anybody know how ...
2
votes
1answer
23 views

Show all x-axis markers for Numbers' bar graphs

With Numbers' bar graph, I'd like to show all x-axis markers of my table, or at least selected few with all the columns present. but only a few is displayed when there are many. The only way to show ...
2
votes
1answer
480 views

Aggregate Table with Numbers.app

I have a table featuring some outcome (column B) versus the day it happened (column A): and I would like to produce another table with the unique dates in the first column and the total outcome of ...
1
vote
2answers
7k views

How to copy a cell formula in Numbers

Lets say I have a formula like (Q7+Q11)÷Q20 in cell O20 and I wanna copy it to another cell, lets say D47, is there any key modifier or shortcut to do it without losing the original references of the ...
5
votes
1answer
344 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
2
votes
1answer
23 views

When using Numbers app, is there a setting to create a new column when user presses tab?

When you are navigating in Numbers, pressing the tab key will take you to the next cell to the right and allows you to start typing. Very quick and helpful for data entry. When the user reaches the ...
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 ...
1
vote
1answer
51 views

How do i change the column type in Numbers from number to string

I have a column in numbers with zipcodes. The zipcodes have leading zeros, only the column drops the leading zeros. I assume this is because the column thinks it's a number and not a string. I tried ...
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
0answers
302 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 ...
0
votes
2answers
107 views

Transfer formula result from one tab to another on iCloud Numbers

On Numbers for iCloud, how do I transfer a formula result from one cell to another on a different tab, but in the same spreadsheet?
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,...
0
votes
1answer
50 views

How to select or autofill all distinct elements from a column in Numbers?

My home banking App can export to Numbers. It will give me a table with date, category, description and amount. I want to extract all the categories automatically in a second sheet. How can I do this? ...
3
votes
1answer
4k views

Merge Spreadsheets

[Numbers, macOS] I need to merge data in 2 spreadsheets / tables. Both of them contain contact information. The second table contains a column that I want to append to the first table. Now, I can't ...
5
votes
3answers
5k views

Open CSV File with Different Separator

I'm currently using the default Numbers application to open my CSVs. My current use case involves a file that I had to use a different type of separator (|). Is there any way to change the separator? ...
0
votes
1answer
65 views

How to add the function to change the colour of a cell on numbers after a certain date has been passed

I am using Numbers on Mac and I am trying to get cells to change colour once a date has been passed, this is to keep track of warranty's of certain products, I want the cells to be green while the ...
3
votes
1answer
47 views

Sum yearly totals automatically

I am using a simple Numbers spreadsheet to track an expense that only comes up a few times per year. I want to be able to have Numbers automatically add the values that come from each year. For ...
1
vote
1answer
2k views

How can I create a running total in Apple Numbers (4.0ff)?

A typical use of a spreadsheet is to create a running total, as for a checkbook register. The usual way to do this is to simply add a current row to a prior row. My example is a variation -- showing ...
2
votes
0answers
60 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
883 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, ...
1
vote
1answer
95 views

Formula required to add time at rest

How can I create a formula that will sum up different times based on certain criteria below? The below table is an example of what my current formula looks like, which is very basic and is changed on ...
0
votes
1answer
261 views

Mac Numbers Shortcut Help

In Numbers (I'm currently running v3.6.2) after I have selected a cell/row/whatever, I want, without irritating my carpal tunnels, to format that text strikethrough. In Excel, I just had to add the ...
1
vote
1answer
42 views

Numbers 3.6: Change text depending on value

Newbie here! I'm trying to find a function so when I enter a value in one cell (A1) it gives me a predetermined word in another cell (A2). The values are ranges (0-19, 20-39, 40-59, 60-79 & 80<...
0
votes
0answers
214 views

Copy cells' content w/o adding quotes - Apple Numbers

I want to copy text from a cell, exactly as it is. However, Numbers (3.6.2) put quotes around my text. Example: This is text inside a cell. When trying to paste the string that I've just copied ...
1
vote
2answers
65 views

How to get total amount for each client in a list automatically?

Let's say I have a long list of clients in one column of a Numbers table, most of them occurring multiple times, and in the adjacent column are amounts due for services received, as depicted below. ...
0
votes
1answer
462 views

Numbers: How to make a sum product of 2 columns numbers of which only those with checkboxes checked in a 3rd column respectively?

Say, sumproduct(A, B)=a1*b1 + a2*b2 + a3*b3, now I have many columns C, D,..., e.g. c1 checked, c2 unchecked, c3 checked; d1 unchecked, d2 checked, d3 checked; Now I need a formulae which I want to ...
0
votes
2answers
99 views

How can one jump to a specific line in Numbers?

In Numbers on a MacBook Pro Early 2013, how can one jump to a specific line, such as line 4223860. The data is actually csv formatted, and I have no clue what is inside that line. Any help is very ...