Thread Hiding or unhiding table rows with AppleScript?
Hiding or unhiding table rows with AppleScript?I have a large table in Numbers, and I want to sometimes view the entire table, and sometimes select a group of rows to hide or unhide, to make viewing the data more convenient. Selecting the numerous rows to ...view more
Thread How do I count unique entries across multiple columns?
How do I count unique entries across multiple columns?I am trying to calculate the total number of unique individuals who attend an after-school program during a given week. Here is what my table looks like: Calculating the total attendance each day and ...view more
how to create gantt chart with numbers?i'm a new user of numbers, as I use microsoft excel to create gantt chart before,it' s easy, but now, I like to use mac numbers, possibly, I'm not familiar with numbers, so i couldn't find a way to solve the date as a...view more
How to mirror another cell?I want to make cell1 (A1) as mirror of cell2 (A2). From the content perspective, I can simply use "=A2" inside A1, and that should do. But let's say I want formatting also to be reflected in A1 whenever I make changes...view more
How to merge sheets with formulaI have a complex tracker with many sheets and cells having formula, with references to other sheets. Now, everyday I need to give this numbers file to multiple different team members, so that each one can update their...view more
Merge Excel data into PreviewHello, I'm using Excel for Mac 2011 and Preview. How would I import rows of data from Excel to populate fields in a PDF document using Preview? The use case is that each row of data is a real estate listing. I want...view more
Thread Conditional formatting based on another cell
Conditional formatting based on another cellHi, Let's say I have a simple tracker as follows: Column A: Task Column B: Completion Date Column C: % Completion I want The entire row to get highlighted in green if I enter 100% in column C. I know...view more
Thread A Matrix using Index & Match from two separate tables
A Matrix using Index & Match from two separate tablesHi All, I have an interesting little challenge - I haven't come across anything quite like this before - Hoping that someone in the community has had a similar dilemma and maybe able to help. Attemptin...view more
Why Won't This Forum Advance Past Page 1Looking for a post I made about Numbers several days ago. Forum will not advance past page 1; just keeps loading with no progress. Looked for a button to find my previous posts but no luck.view more
Numbers Crashing on SierraI'm running Numbers 3.6.2 on macOS Sierra Build 16A304a (Public Beta 6) on a mid-2010 MacBook 2.4GHz Core 2 Duo with 8GB RAM. I have an Expenses spreadsheet where, as the name suggests, allows me to input all ...view more
Thread Once a certain number is reached in tally -drop to zero
Once a certain number is reached in tally -drop to zeroI have a column with each row successively larger as each row contains the tally of the row above it plus a new figure. HOWEVER, once the tally comes to a certain number (found in a separate cell) I want all further r...view more
Can I print each table on a new page?When using Numbers, I often have multiple tables within any given sheet. Like this: When I print the sheet, this often causes tables to be split onto multiple pages. Like this: It's v...view more
Want to auto populate a popup menuHi! I'm looking for a way to auto populate a popup menu with data from a column on a separate sheet. On Sheet 1 I have a bunch of products names listed in column A (with their prices and taxes in columns B onwards.). ...view more
Maximum number of simultaneous filtersHi, I've found out that when reaching 8 different filters on a spreadsheet, the option to add a new filter gets greyed out. Is there a possibility to increase that number? Thank you.view more
numbers column recallHi, I'm using numbers v3.6.1. We have a database of all equipment we own with rows stating the make, model number, serial number, description price per day and so on. What I want to be able ...view more
