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
Filter by
Sorted by
Tagged with
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 = # ...
Chris's user avatar
  • 1,238
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 (...
Lasse V. Karlsen's user avatar
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 ...
Bluebug's user avatar
  • 195
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, ...
SystemGuru123123's user avatar
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.
whitesiroi's user avatar
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 ...
shaboinkin's user avatar
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/...
Riccardo's user avatar
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 ...
J.Doe's user avatar
  • 141
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 ...
J.Doe's user avatar
  • 141
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 ...
candez's user avatar
  • 13
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] | ...
Born2Discover's user avatar
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 ...
orlando lopez's user avatar
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,...
Felix G's user avatar
  • 111
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 ...
Jono's user avatar
  • 1
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 ...
Bluebug's user avatar
  • 195
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 >=...
cglacet's user avatar
  • 99
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 ...
TD540's user avatar
  • 191
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 ...
Anton K's user avatar
  • 121
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 ...
Azmodeus's user avatar
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 ...
Muskoka Mary's 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?
tom's user avatar
  • 43
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 ...
Nate Weatherly's user avatar
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 ...
David.Chu.ca's user avatar
  • 5,145
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?
user473973's user avatar
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 | ...
endo.anaconda's user avatar
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 ...
Joe's user avatar
  • 1
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 ...
korbatz's user avatar
  • 101
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 |...
Philip's user avatar
  • 1,595
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 ...
dang's user avatar
  • 101
-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 ...
citizen's user avatar
  • 107