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
67 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
92 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
17 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
521 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
59 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
82 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 ...
11
votes
3answers
23k 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
9k 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
25 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
151 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
28 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 ...
28
votes
5answers
95k views

How can I do text-to-columns in Numbers?

I've got a column where each cell in the column contains two different pieces of data separated by a known delimiter ", ". How can I split each cell in this column around the delimiter? Given: ...
12
votes
3answers
8k views

How do I keep Numbers from mangling numbers when importing a CSV?

When I open a CSV file in Numbers, it "helpfully" converts fields it recognizes as numeric by stripping leading zeros, converting things it recognizes as dates, etc. Take for example, you type a UPC ...
3
votes
1answer
23k 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
434 views

Naming a Cell in Numbers

Can you define a cell's name in Numbers for use in formulas across a workbook like you can in Excel?
1
vote
0answers
32 views

How does one separate a Numbers spreadsheet with multiple (4) tabs into separate files?

I have been given a spreadsheet with 4 separate tabs/sheets. I would like to separate them into different files. I know that I can cut-and-paste and create new files but is there a simpler/easier way ...
7
votes
2answers
5k 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 ...
1
vote
0answers
27 views

Keep a Numbers chart stationary while scrolling the page?

In Numbers, is there a way to make a chart stay visible at the top of the page while I scroll down through the rest of the page's contents? Similar to how a table's header row can be made to stay ...
1
vote
1answer
339 views

Numbers: hotkeys to choose cells in formula edit mode

When I edit formulae in Numbers, is it possible to select nearby cells using the cursor keys? For example, I might be editing cell C3, and set its formula to "=B2+C2". I would like to select cells B2 ...
1
vote
1answer
531 views

Get values from Numbers.app into AppleScript's variables

I have a .numbers file in following format: Product Quantity Price Apple 5 3 Banana 7 2 Orange 3 4 I need to get three variables with new-line separated values, e.g. ...
1
vote
1answer
36 views

Numbers version 5.3(5989). How to Calculate Duration by comparing two cells formatted as datetime?

Column A has been formatted in the “datetime” format. Date and time from my glucose meter were entered into Column A and displays as in the default option I selected. Column D is the glucose readings ...
1
vote
1answer
37 views

Unmerge all cells in Numbers xls file

In this situation I have 2 cells merged into 1. How can I unmerge it so the result will be 2 cells with the same data? I have cases with up to 7 cells merged in the xls file. How can I unmerge them ...
0
votes
1answer
32 views

Numbers help me work out my gas consumption

Trying hard to work out my yearly gas and electricity consumption. I have forumla for SUMIF: =SUMIF (B,"="&F6,Gas Reading) But I think I want to do (IF the year is 2015 [F6 entry], then find ...
2
votes
1answer
1k views

Prevent Safari from transforming downloaded CSV files to Numbers files

On a computer that has Numbers installed, downloading a CSV file will automatically be converted to a Numbers spreadsheet and no longer be a plain CSV (not just the extension, but the contents ...
1
vote
2answers
1k views

The index.xml file is missing

I like using numbers 2.2 but also have 4.3.1 installed. I would much rather use 2.2. as its been working all along and because I like the format bar which is not in 4.3.1. I've been using "Open With"...
0
votes
1answer
180 views

Numbers not sorting dates correctly

I cannot get the column to sort the dates correctly in Numbers! I want to sort the column by date and instead of sorting 1 through 12, it sorts like this: 1,10,11,12,2,3
3
votes
1answer
14k views

How to sort column by date in Numbers?

I've my column in format dd/mm/yyyy and I would like to sort them by date. But I can't find any way of sorting the column by date. If I Sort Ascending, it doesn't recognise that the rows have the date ...
0
votes
2answers
246 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?
0
votes
0answers
27 views

Mac Numbers equivalent to Microsoft Excel's Control+Arrow Keyboard Shortcut

Is there a feature in the MacOS Numbers application that allows me to jump to non-empty cells? In Excel if I hold the control key and press any of the keys ←↑→ or ↓ the cursor will navigate to the ...
1
vote
1answer
35 views

Numbers for macOS: how to update a column of entries

In Numbers for macOS I have a column of entries, each entry (field) is just a single word. How can I update the whole column such that each entry will look like that instead: <img src="...
0
votes
0answers
57 views

Numbers function that returns the location for the current cell

It appears that Numbers does not have user defined functions so I am writing a rather complicated expression in Emacs and then pasting it into the cell to use as an equation. I'd like to reference in ...
1
vote
0answers
14 views

Is there a function in numbers that allows to select elements that have an index congruent to 2 modulo 3 for its row, from a given column?

I want to select and do the average of one every 3 numbers and the row index of the first is 5. So I want to select 5,8,11 etc Is there a way to do it in Numbers?
0
votes
1answer
872 views

Numbers: how to search only within a selected range?

I have a very big table, and searching for a string can take a few seconds. However, I only want to search in a particular column. Even when a column is selected, Numbers searches the entire table. ...
0
votes
1answer
595 views

Is there a way to reverse the order of rows in a chart?

I'd like to change this chart to the following one: So, I'd like to reverse the order of rows. According to an answer on a similar question, you need to create a formula and put it in each cell ...
1
vote
0answers
38 views

Is it possible to “lock” and prevent adding new columns in Numbers?

Is it possible to lock the number of columns in a Numbers sheet so that no new columns are added on the right when tabbing through cells? The problem is when I tab through cells from left to right, ...
2
votes
1answer
168 views

Can I use variable in Numbers cell formula?

I have to write a complex formula like this: IF(5−SUM(C35:I35)>0,5−SUM(C35:I35),"") Can I define a variable for 5−SUM(C35:I35)?
2
votes
0answers
32 views

How do I check if a date is between 2 dates?

In the above example, how would I get the “period” (column C of the Example table) of a certain date (column B of the Example 2 table) using the start and end dates (columns A and B of the Example ...
0
votes
1answer
32 views

How do I reference a cell from within a “…IF”-type function condition string?

When using a ...IF type of function (like COUNTIF, AVERAGEIF, etc.), I use condition strings: e.g. ">100", "=Mr. Smith" Instead of using a literal from within the string, how do I (or can I) ...
1
vote
0answers
595 views

Numbers - “the index.xml file is missing” [closed]

I am running OS X Yosemite on my Mac 10.10.5. I have Numbers files saved. When I try to open them, I get "The index.xml file is missing." How do I open these files?
3
votes
3answers
54k views

How do I start rows with 0 (not 1) or not count header rows in Numbers?

I'm using the Numbers app to make a database or catalogue of stuff. For example, a list of all wines I'll try this year. And for each column, I'll have the name of the wine, a rating, the kind of ...
2
votes
0answers
23 views

Paste a formula in numbers 4.2 without altering format of recipient cell

How do i paste a formula in numbers 4.2 without altering format of the target cell? I’m sure this used to be easy, but can't seem to do it. I want to paste a formula from a colour filled cell to a ...
2
votes
1answer
322 views

Numbers error: not enough space in iCloud

I recently maxed out my iCloud storage for a few weeks, meaning things like backups and photo uploading would not work. Eventually, I deleted some unwanted files, and now there is plenty of free space ...
0
votes
1answer
117 views

How can I find duplicate adjacent cells in Numbers?

I have a Numbers sheet that is thousands of rows long. As an example in the image, the sheet has two columns with URLs. What I need to do is find the rows that have the same URL in the two adjacent ...
0
votes
1answer
33 views

Numbers - Perform arithmetic on a section of cells

I have a column of cells and I want to do 41 - (value of cell) for each individual cell without having to go through doing it manually. I know this seems simple but I can't think of an easy and quick ...
2
votes
1answer
71 views

Is there a formulaic way to reverse the order of a list in Apple Numbers?

For example I have a list of numbers in a column. I would like to have another column that takes whatever is in that list and reverses the order the list appears. Is there a way of doing this with a ...
1
vote
0answers
13 views

Comparing times in Apple Numbers

I am using the latest version of Apple Numbers on iOS. I have a table with a Date/Time column, with values being: =TIME(0,0,0) =TIME(0,30,0) =TIME(1,0,0) and so on, in half-hour increments, for the ...
2
votes
2answers
555 views

How can I make calculations based on smart category summaries in Numbers?

The latest version of Numbers has a great feature called Smart Categories that are kind of like Excel's pivot tables. I'm using it to group a table by a label and then sum up spending and revenue ...
1
vote
1answer
2k views

Hide sheets in Numbers?

Is there any way to hide sheets in Numbers? (like in Excel) I have tried everything other than delete, since I may need to refer back to them.
1
vote
1answer
1k views

Is there a way to import stopwatch data into Numbers?

I use the stopwatch app to collect data sometimes, and often I'll have ~100 datapoints. (as an example, my light creaks periodically after I turn it off after leaving it on for a long time, so I timed ...
5
votes
4answers
22k views

How to convert .number file to any of the readble format including excel and pdf without having mac

I have an important .number iworks file. My Mac is now no more... How do I convert .number file to any of the readble format including excel and pdf without having mac.

1 2
3
4 5
11