option command v dosent work So at first it did work then it made my text size so mucho bigger and then it just didn't work! HELPview more Want to auto populate a popup menu Hi! 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 Once a certain number is reached in tally -drop to zero I 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 numbers column recall Hi, 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 How can I order by alphabet the list created on a dropdown menu? How can I order by alphabet the list created on a dropdown menu?view more COUNTIFS specific year Hi, I'm having difficulty coming up with a formula that works, so I'm turning to the community for help. I'm not sure if it's my formula, or if it's possibly a data formatting issue, but I have a flight log, a...view more Conditional Formatting Rules Not Working I have OSX 10.10.5 and Numbers 3.6.1. I have been working with spreadsheets that use conditional formatting rules to apply a colored fill to cells. True values are filled green and False values are filled red....view more Getting Stock Quotes Into iWork 3.1 A few months back I was scouring this community for instructions on how to get stock information into iWork. Folks like Yan Koenig and Bob H. posted some suggestions and I think I was this close to success whe...view more Entering transactions in Numbers Hello, I am very new to numbers and making a budget. I am using a budget template found on Numbers on my ipad. So far I have filled out the budget sheet (entered my own expence categories and expences and budg...view more Numbers formula help using date ranges I hope I can explain what I am needing well enough to make sense. I have two charts. One is used to track job bids in the form of money, dates, total awarded and so forth. This chart contains a date column (Co...view more MS Excel and Mac Numbers Thoroughly confused new guy here. Run an Excel spreadsheet (2013) on Windows 7 and just bought a new MacBook Air 13 with Numbers. Discovered my MacBook can "read" my Excel spreadsheet downloaded on USB dri...view more Formula works in one row, but same formula (copied and pasted) will not work in other rows. I have a formula that, if there is a number in the box, multiplies it by a price, then sums the results in a final column. I copied it into 7 rows. It changed the row numbers as necessary, the formulas all look right,...view more That SUMIF function - an idiot question This is my first attempt at spreadsheeting and like my first attempts at skateboarding I seem doomed. However I have persevered and with help from forum members have made a very useful financial tool. I now have a s...view more Formula or counting a specific letter in a row or area ? At the moment, I am creating a water polo stats sheets that records a players stats by assigning them certain characters. I need a formula that counts a specific letter in a row or an area of cells and displays the co...view more Sum total income for each unique client and chart it!? Greetings from sunlit Athens! I have been scouring for the past 5 hours for an elegant solution to the following: I would like to sum the total amount of income for each unique client and chart it to vis...view more How can I create a chart that creates new series every year when the data is not collected daily? I collect numbers from my solar system "occasionally", and want to create a normalized graph that shows that generation on a yearly basis so I can compare fall to fall each year, etc. Since the information is ...view more Using page number / page count in formulas Hi. I'm seeking for a solution, that I can display a value/text in a cell (If…then…), e.g. when the page count is higher then 1. Unfortunately 'Numbers' (3.6.2) couldn't handle the page n...view more SUMIF row is equal to test value and row below is '-' Hello, I have a numbers spreadsheet where one column has a list of names that are mixed up with repeats, and another column that has a list of profit values relating to that name. Now, I want to determ...view more Using Applescript to copy cells from one document to another Hi! I just finished completing my first "Real" Applescript to do something that I thought would be fairly simple. It only took me 5 days to figure out! Anyway, I regularly create new Numbers document...view more how do i stop predictive text in numbers Hi all does anyone know how to stop preditive text in numbers 09?view more