Questions tagged [iwork-numbers]
Numbers is a spreadsheet software included in the iWork productivity suite by Apple.
30
questions with no upvoted or accepted answers
4
votes
1
answer
3k
views
Numbers conditional formatting based on a different cell in the same row
I have a Numbers spreadsheet, with "quantity required" and "quantity in stock" columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # ...
3
votes
0
answers
265
views
In Numbers for Mac, possible to have custom formatting depending on value of other cell?
I have several columns of numbers, and I want to highlight one of those with a background color.
I have created a single cell at the top of these columns, that for each column contains either a 1 (...
2
votes
1
answer
2k
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 ...
2
votes
0
answers
402
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, ...
2
votes
0
answers
712
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.
1
vote
1
answer
62
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 ...
1
vote
1
answer
927
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/...
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 ...
1
vote
0
answers
215
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 ...
1
vote
0
answers
73
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 ...
1
vote
0
answers
408
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 | [email protected] | ...
1
vote
1
answer
243
views
Ms Excel or Apple Numbers import rules
I have an Excel file from which I need to export specific colums and place them in a separate file. Is there a program in Windows or Mac, which allows me to set the rules and have these saved for ...
1
vote
0
answers
411
views
How to plot this in iwork-numbers
I have an array of data like this
0,1
0,56
0,4
0,57
0,6
0,006
0,34
0,46
...
I have another array of data that classifies the data above in categories like this:
from 0,1 to 0,5 category A
from 0,...
0
votes
0
answers
8
views
Trying to have autocomplete enabled for a sheet in Numbers on macOS that is pulling the names from a list on a second worksheet
I have a list of roughly 150 names in a single column on a worksheet in Numbers. I run a weekly report that needs to include some of the names and omit others. My goal is to have the weekly worksheet ...
0
votes
0
answers
139
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 ...
0
votes
1
answer
67
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 >=...
0
votes
1
answer
114
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 ...
0
votes
0
answers
54
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 ...
0
votes
0
answers
39
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 ...
0
votes
1
answer
224
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 ...
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?
0
votes
1
answer
7k
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 ...
0
votes
1
answer
40
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 ...
0
votes
0
answers
130
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?
0
votes
1
answer
409
views
How to create a line diagram with non-linear date points?
I have a spreadsheet with numerical data like this:
01.01.2011 | Val1 | Val2 | Val3
03.01.2011 | Val1 | Val2 | Val3
03.01.2011 | Val1 | Val2 | Val3
05.02.2011 | Val1 | Val2 | Val3
17.02.2011 | Val1 | ...
0
votes
1
answer
531
views
Make a differentiated barchart using numbers
I have a question about Numbers.
I want to make a bar chart that shows the membership of my organisation.
I want to divide between unitary organisations and membership organisations, so i want ...
0
votes
0
answers
45
views
Chart from groupings
Given such a spreadsheet:
col1 | col2 | col3
-----+------+----
alfa | foo | 10
beta | foo | 20
gamma| bar | 12
delta| bar | 42
I'd like to generate a chart grouping values from col2 and ...
0
votes
1
answer
84
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 |...
0
votes
1
answer
128
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
...
-1
votes
1
answer
384
views
Rearranging spreadsheet data
If I have the following data table:
Country 1990 2000 2010 LEB 1990 LEB 2000 LEB 2010
Afghanistan 15 17.72 18.24 48.60 54.86 59.61
...
How would I in an automated ...