Thread Numbers spreadsheet won't open on my Mac Air
Numbers spreadsheet won't open on my Mac AirI created a Numbers spreadsheet on my Macbook Pro very recently and mailed it to my friends Macbook Air. She can't open it. Message comes up saying can't open this file. Both computers are less than 4 years old. Only ...view more
Thread Using Applescript for formatting rows in Numbers
Using Applescript for formatting rows in NumbersI have a Numbers spreadsheet where I would like to shade the rows depending on the values (even/odd) in my second (B) column. I've been all over the forum, but I can't seem to find a script that matches, and I...view more
Use of number formulaNumbers 3.6.2 Header 1 Header 2 Header 3 Header 4 Header 5 7:00 x z y I need to solve a problem. The header 1 is a duration. If in header 2 or 3 is present x the value in header 1 will be copied in header 4....view more
Thread Automatic calculation at the end of every month
Automatic calculation at the end of every monthNumbers 3.6.2 I need to have the value of one cell added to the value of another cell at either the end or the beginning of every month. It seems like it should be fairly simple to do but I can't seem to figure ...view more
Numbers has a bizarre problemproblem with numbers spread sheet When I select a cell then type my required formula of - 1/(cell a/cell b) this happens: After I type 1 and then type the divide symbol it simply types the + again and ag...view more
how to calculate across sheetsHi. I have a Numbers document with multiple sheets. How can I calculate the subtotals from each sheet in one cell on the last sheet? Thanksview more
'Questions students missed the most' graphI'm a math teacher, and want to get a graph and some stats about which questions were missed, and have a nice visual graph of that and get some statistics from there. I'm having trouble getting this done, not sure if ...view more
Thread volume size to support permanent storage of Numbers File
volume size to support permanent storage of Numbers FileI have a Numbers file that I store in an encrypted disk image. Every time I exit, after making a change to the file I get the following message - "The document “Words handheld.numbers” is on a volume...view more
Thread numbers text to rtf or pages (without formatting)
numbers text to rtf or pages (without formatting)i have a very comprehensive list of items in two columns that i would like to move to a pages or rtf document. i have removed the cell colors and the outlines and seem to have been able to paste it into a rtf ...view more
Auto-Populate AgendaHi, I'm trying to automatically populate a "Daily Agenda" from a "Task Chart" as in the picture below. When the date of the daily agenda is changed I'd like the tasks and details from my task chart to automatic...view more
how to print selected cells in numbersDoes anyone know how to print selected cells in a Numbers spreadsheet, rather than printing the entire sheet? Also, how to save the selected cells as a pdf file without saving the irrelevant cells?view more
IF funktionHi, I have a checklist and if B3 is checked the value of F3 is displayed in G3 and G should accumulate (see screehshot) (IF B3=TRUE;F3) works with row 3 to accumulate I used the formular (IF B4=TRUE;F4+G3) but...view more
This may be tricky...So I have a couple amortization tables (not shown) that I'm working on with one for 5 and one for 10 years. In this graph (that works off the amortization tables) I'm working with results from each table. It's c...view more
Excel 2011 Corrupt Files from .xlsmI've been dealing with this issue for several months. I receive an .xlsm file from a remote coworker, who is Windows based. Opens perfectly the first time after receiving. Then I work on the file, save and close. Go t...view more
Calculate the mean per time slot ?Hi Chaps, I'm an absolute beginner on Numbers (almost everything on Mac i would say) and i need help to calculate mean values. Those are calculated values (Column 2) taken on a precise moment of the day (Colu...view more