Questions tagged [iwork-numbers]

Numbers is a spreadsheet software included in the iWork productivity suite by Apple.

Filter by
Sorted by
Tagged with
0 votes
1 answer
75 views

Can we add tags in any spreadsheet software like we can in Notion?

I’m working on long tables (like a database or repository, no mathematical function) and I need to refer a few cells in another sheet And also use some tags for each row. I know in Notion, you can ...
user avatar
  • 145
0 votes
0 answers
55 views

Count number of matchups

I use a spreadsheet to track tennis matches played and the result with two friends. I am wanting to count the number of times that each matchup occurs. For example the players are Byram, Heck, and Ray....
user avatar
  • 1
0 votes
1 answer
12 views

How do I make the row and column labels visible all the time in Numbers?

For instance, row and column labels are visible ONLY if you click on the spreadsheet But if you click off of the spreadsheet, they vanish. I do not see a setting to show the row/column labels all the ...
user avatar
0 votes
0 answers
31 views

Numbers: How to add or subtract hours for a column with date-time value?

Please note that this questions is about Numbers and not Excel. Givens: column x has values of format yyyy/mm/dd hh:mm column y has empty values Desired solution: column y to have values from column ...
user avatar
  • 1
0 votes
0 answers
45 views

How to bring sum of previous column in to next column automatically, in Excel or Google Sheets?

I'm new to this. I'm trying to make a personal budget sheet, where I can bring the previous months' sum into the next month's column as "savings from last month". Basically I want to show ...
user avatar
  • 145
0 votes
1 answer
240 views

In Apple Numbers what formula can calculate the amount of days in a certain month across 2 dates

I copied and pasted an identical question regarding Excel. I tried following the solution in Numbers but I always get this error message "the operator "*" needs a number but it found 01/...
user avatar
0 votes
1 answer
66 views

First cell such that <condition>

Giving a range of cells say A1:A4 how can I get the index i of the first cell such that Ai is greater than x. For the sake of the example, suppose cell Ai contains 10^i. I have: MATCH(TRUE; A1:A4 >=...
user avatar
  • 99
0 votes
1 answer
48 views

Multiple languages in Apple Numbers

I need to reformat a whole bunch of dates from 1/1 to Wednesday 1/1 in the English column and Mercredi 1/1 in the French. But it seems like in Apple Numbers (version 6.2.1) you can only select one ...
user avatar
  • 171
1 vote
1 answer
21 views

Append character to beginning of each new line in Apple Numbers

Ive got cells with the following data, each ingredient for a recipe is in a new line in the same cell. I need to add a pipe | at the beginning of each line but not the first. Is it possible to do this ...
user avatar
  • 21
0 votes
2 answers
49 views

How can I create small random groups containing one unit each from five sets of data?

I have five sets of data. I want to create small random groups containing one unit each from all five sets. Thank you.
user avatar
1 vote
1 answer
38 views

Finding the Last Non-Empty Cell in a Row With a Particular Set of Values

I have a spreadsheet of student data, where each row is a single student. For any given class, there are multiple columns 1-N, where N is the most number of times any of the students has repeated the ...
user avatar
0 votes
1 answer
7 views

How to add padding above the highest data in the chart

I have a chart that the values go to the top of the chart. Is there a way to add padding above the highest data in the chart? In the image attached I'd like to have padding above the orange data.
user avatar
2 votes
0 answers
282 views

Pages and Numbers Password-Protect Feature: What Type of Encryption?

I am interested in the security of the feature mentioned in the article below: https://support.apple.com/kb/PH23229?locale=en_US&viewlocale=en_US The article mentions that encryption is used, ...
user avatar
0 votes
1 answer
284 views

How to deselect a column from a chart or graph in iWork Numbers?

When I select a chart and press Edit Data References it shows the columns I've selected. How do I unselect or delete a column or some cells? In my first column of data I want to deselect the first ...
user avatar
1 vote
1 answer
117 views

Can you use JavaScript or text formulas in Apple iWork Numbers?

Is there a way to use JavaScript in Apple iWork Numbers? I'm having trouble adding a Round function around my existing function and it's showing errors. It says it contains an error but doesn't say ...
user avatar
0 votes
1 answer
211 views

How to select multiple columns in Numbers?

In Numbers I have one column of values and in the next column I want to be values of the first column. I've got it to work with one column cell but when I select the whole column it gives an error. ...
user avatar
2 votes
3 answers
17k views

Numbers: Export CSV with different separator

In a Mac when you export CSV files they always put a comma separator, this can break really bad the documents. Is there a way to export with different separator (like '\' or 'tab')? Even better, is ...
user avatar
  • 123
0 votes
0 answers
38 views

Copy values from a column only if they contain a word from another column

I have two columns: The first one contains words (column "A" on the screenshot). The second column contains text values (column "C" on the screenshot). I'd like to copy the words from the second ...
user avatar
  • 121
1 vote
0 answers
8 views

How to sum up products like this?

I am creating a spreadsheet to keep track of large expenses. The idea is that I virtually finance things rather than actually do it that way when budgeting. The idea is that if I make a large ...
user avatar
  • 141
1 vote
0 answers
182 views

In Numbers/Excel how can I do a SUMPRODUCT only on rows matching a specific criteria

Let me explain my spreadsheet a little bit. Here is a good screenshot of it: I have created this spreadsheet essentially because I have gotten tired of the usability issues of just about every ...
user avatar
  • 141
0 votes
1 answer
101 views

Formula in Excel or Numbers to generate a series of numbers

In my spreadsheet I have two numbers, start_number and nr_iterations. I'm looking for an formula that returns a series of numbers starting with start_number - 1 and nr_iterations long (each following ...
user avatar
  • 291
1 vote
1 answer
2k views

How does one add hours to a datetime in Apple Numbers?

I have one column that has a start date, and another column that has a duration field in hours. I cannot figure out how to add the hours to the datetime field.
user avatar
  • 313
2 votes
1 answer
1k views

Apple Numbers - Conditional formatting with equation

I want to color a cell green if it’s ≤ A1 × 2. I can do this with a conditional formatting rule in Google Sheets, but conditional formatting in Numbers seems not to support equations, only ...
user avatar
  • 211
4 votes
1 answer
950 views

Pasted tab separated plaintext doesn't end up in multiple cells

A recent update to Apple's Numbers seems to have removed or broken the ability to paste into multiple cells. Previously, if I copied the string A\tB\tC (where \t represents a tab character), I could ...
user avatar
  • 141
0 votes
1 answer
80 views

Spreadsheet: find a cell keyed by date

This is a question about Apple Numbers spreadsheet program. Suppose I have two sheets: Benchmark and Training. In the Benchmark sheet, I track a benchmark value over time: | Date | Benchmark |...
user avatar
  • 1,485
0 votes
1 answer
138 views

Convert Numbers file to Excel file

I have a spreadsheet created on a Mac using the software "Numbers". In which way can I convert it into an Excel file to modify it on a Windows pc?
user avatar
1 vote
1 answer
381 views

Sum specific cells if other cells match source cell in Numbers on Mac

So, I'm making a personal budget table that is similar to YNAB in functionality. I want to use Numbers but I can easily switch to Excel if this can't be achieved. I have two sheets; Budget and ...
user avatar
  • 113
0 votes
1 answer
125 views

Remove non-duplicate rows from Numbers

I have Numbers file in Mac OS with 3 columns GEO_ID GEO_ID2 FIPS 05000US01001 1001 12121 05000US01003 1003 28061 05000US01005 1005 21095 05000US01007 1007 28023 ...
user avatar
  • 101
5 votes
2 answers
177 views

Determine United Airlines status level using worksheet functions

United Airlines MileagePlus Premier status levels are determined by a combination of criteria: Silver: (PQM>=25000 OR PQS>=30) AND PQD>=3000 Gold: (PQM>=50000 OR PQS>=60) AND PQD>=...
user avatar
0 votes
0 answers
38 views

Data Entry Beginner Asks: How do I 'section' out rows of a spreadsheet to belong to a product/item/object?

I am a complete beginner to data entry and wanted to know how to accomplish the following with the sample dataset provided below. Search through quantity column for "equal to or greater than value of ...
user avatar
0 votes
2 answers
2k views

How to add a row without changing formula in Numbers app on Mac

I have rows of data sorted by date (descending). Therefore it is important that a new row can be added above all other rows but before the "header" row. However, when I select "Add row above" the ...
user avatar
7 votes
1 answer
10k views

Apple numbers: How can I create a filtered column (B) with only unique values from column (A)?

I'm using Apple Numbers. I have a table with data like: A | B ---------+--------- Spain | U.K | Spain | Germany | U.K | Italy | And I would like to set table B to include ...
user avatar
  • 183
0 votes
3 answers
98 views

How can I count the number of cells that match a given month in Numbers

I'm using Apple numbers to run some calculations on CSV export data from Mailchimp. The data is (loosely) like: ID Email, SignupAt 01 me@example.com 2015-09-04 02 you@example.com ...
user avatar
  • 183
9 votes
2 answers
31k views

Apply formula to entire column using numbers app in osx

I use osx numbers app. I have a large CSV file. And I want to apply a formula for an entire column. Adding formula to a cell and then dragging is not practical. Isn't there any other way?
user avatar
0 votes
1 answer
55 views

Extended Subtraction Between Columns on same row in area

I want to calculate the transaction value so by that i mean i've got different accounts in column "A" and for each transaction i got a column like "B". The transactions show the new value, after the ...
user avatar
  • 3
1 vote
0 answers
68 views

Performing calculations on durations in iWork Numbers

I have a time sheet that I use to bill clients, with the following columns: A: start time; B: end time; C: calculation of B - A, resulting in the duration of time worked; D: Project name On another ...
user avatar
  • 13
1 vote
1 answer
1k views

iwork numbers and apple Swift language relation

Is there any way to write Microsoft office Excel macros like scripts for iWork numbers code using apple's Swift programming language?
user avatar
  • 113
1 vote
1 answer
67 views

Full grid canvas in Apple Number

Apple Number have a default blank canvas shaped as a sheet with margins. Is it possible to change the default blank canvas to an endless grid like Microsoft Excel?
user avatar
  • 111
0 votes
2 answers
1k views

Find the number of cells to sum to reach a certain amount

I have a column of values (they are ordered if that matters): A:A. I have two values: a starting value B1 which is also present somewhere in A:A, and a goal value C1. Let's say the we can find the ...
user avatar
  • 626
0 votes
1 answer
191 views

Numbering lists in Apple's Numbers

This should be so simple. I am attempting to use "Numbers" Mac's spreadsheet program. All I want to do is make a list of people and number them. I want the gridlines - and I want the list of ...
user avatar
0 votes
0 answers
41 views

Numbers or Excel, Sum data in a column depending on date

I hope to Sum Column Y based on data in column A. That is, If A is in (contains) "July", then sum Y. i.e. "What are the totals for July?
user avatar
  • 43
4 votes
2 answers
2k views

In Excel (or Numbers) what formula can calculate the amount of days in a certain month across 2 dates

If a guest arrived on 24th of August and left on 4th of September what is the formula(s) to calculate how many nights are spent in August, and how many nights are spent in September?
user avatar
  • 43
1 vote
0 answers
524 views

Go to specific row number in Numbers (OSX)

Is there a way in Numbers to go to a specific row number? For example I need to find an alternate way to not have to scroll but rather can immediately go to row # 3000.
user avatar
1 vote
1 answer
2k views

Display Last Value from End of Row in iWork Numbers

In iWork Numbers (v3.5.2) I would like to display the last value (not int or bool) from a row. I have an image of what I'm looking to do below. In row 1 I have the Current pulling the value from the ...
user avatar
0 votes
1 answer
6k views

Spreadsheets Formula Check In/CheckOut Autopopulate Data

I am working on a spreadsheet (I am doing it in Numbers since it will easily let me work on the file on my mac, iPhone, iPad and online at icloud.com)... but this is essentially also an excel question ...
user avatar
0 votes
1 answer
29 views

Val2 function in iWork Numbers?

Is there equivalent Excel Val2() function in Numbers? I want to get value of a cell, which contains formula. What I need to get the result text from the cell. The following is example data: A B ...
user avatar
  • 4,475
1 vote
0 answers
407 views

Pull multiple rows of data from one place in spreadsheet to another based on a condion

I have an iWork Numbers (3.2 - 1861) sheet with a list of people with the following structure: | Name | Age |  Email | Condition | | Bart | 12 | test@test.com | ...
user avatar
0 votes
0 answers
83 views

Make a column be unaffected by any row in Excel?

Basically I want to keep a particular column unaffected by any row deletion (by unaffected, I mean no contents of that column are shifted). Is this even possible?
user avatar
3 votes
1 answer
1k views

Categorizing data based on a column in Numbers 3.X

I have recently migrated to numbers 3.0.1 on my MAC. I am not seeing the option "Categorize by this column" anymore. Any idea how do we group the data in new numbers based on a column.
user avatar
  • 345
0 votes
2 answers
504 views

Define a range based on the result of the INDEX function

In Excel it is possible to write a function looking like that: =SUM(A1:INDEX(...)) Where the end of the range of the data to sum is dynamically defined by the result of the INDEX function. The same ...
user avatar
  • 626