Per prior message, found a way to copy a formula down a column, still having issues making names for ranges work and now can’t for the life of me find a way to add a pivot-table. Once again, any help gratefully accepted.
Thanks Garth > On 21 Feb 2015, at 4:58 pm, Garth Humphreys <ghu...@gmail.com> wrote: > > Hi Phil, thanks for your help. Okay, starting to get somewhere. Never been a > fan of formula editors, usually just prefer to type it straight in., but > getting the hang of this one. The place holders keep getting in the way more > than being helpful sometimes though. I’d really like to be able to just arrow > through the text like it was a normal text field but I guess it will come > with use. The auto complete stuff seems pretty similar to excel in the most > part, obviously you just hit tab rather than enter though. Excel will do the > auto complete for a defined range,which I really like. Okay some more > questions, > Still don’t get how the name for a range works, so I have some data in 3 > columns, let’s say Names, Age, and Sex. of 20 people. This data exists from > A2:C21 and I have the Headings Name, Age, Sex in A1, B1 & C1. The formula > editor offers me the first persons name as a range or Name as a range however > selecting either of these did not work. Lets say I want to call this data set > “Staff” and refer to it in formulas by that name, should I add a row above or > a column before the data? Neither of these seemed to work.I could make the > formula work by using absolute cell range but I’d like to get the defined > name way of doing it to work. > Also, in excel, if I want to make a cell reference absolute, I just type it > in say D22 then hit F4 and it’ll expand to $D$22, is there some quick way to > do this in Numbers. > How about dragging down a formula over a lot of rows, like Control+D in excel > to copy the first cell in a selection down the entire selection? > > Thanks again, > Garth >> On 21 Feb 2015, at 11:55 am, Phil Halton <philh...@gmail.com >> <mailto:philh...@gmail.com>> wrote: >> >> >>> On Feb 19, 2015, at 11:21 PM, Garth Humphreys <ghu...@gmail.com >>> <mailto:ghu...@gmail.com>> wrote: >>> >>> Just started playing with numbers on the mac for the first time, I’m an >>> excel user at work. >>> 1. Can you define a range with a name so you can just reference the range >>> with that name? >> Yes, place your range name in a header row, (it must be the header row >> closest to the data rows), and the formula editor will make that range name >> available when selecting ranges/cells. >> >>> 2 What’s the syntax for referencing a table or range on a different sheet >>> and or file? e.g., I’m trying to do a Vlookup where the table is on a >>> different sheet, what’s the best way? >>> The formula editor is great for this. simply start typing the name of the >>> sheet and the editor will attempt to auto complete the sheet name. when >>> you hear the completed sheet name, press enter and the editor will start >>> providing table names. use the right arrow to move through the available >>> tables, or just start typing the name of the table and again, the formula >>> editor will attempt to auto complete. press enter when you hear the table >>> name you want. next, the editor will start providing range names. follow >>> the same steps as you do with sheet and table names. Again, whenever a name >>> is called for in the formula, just start typing the name of the desired >>> sheet, table, or range and numbers will do its best to auto complete. >> >> Spend some time working in the formula editor to get familiar with its >> operation and you’ll love it, its miles ahead of excel in this regard IMO. >> >> for absolute ranges, use the (dollar sign in front of the cell/range, just >> like in excel. >> >> if you don’t want to use the auto complete, , I think the exact syntax is to >> type the sheet name, followed by two colons, then the table name, followed >> by the range/cell name. I can’t remember right now what the separator is >> between table and cell/range, but a good read of the numbers help system >> will answer all the specifics, its a really thorough help system. >> >>> That’ll do for a start, thanks for any assistance. >>> >>> Garth >>>> On 19 Feb 2015, at 8:04 am, waterwogs...@gmail.com >>>> <mailto:waterwogs...@gmail.com> wrote: >>>> >>>> Thanks so much! >>>> On Wednesday, February 18, 2015 at 8:11:51 AM UTC-8, waterw...@gmail.com >>>> <http://gmail.com/> wrote: >>>> Wondering if anyone knows how to do in-cell editing in Numbers? >>>> >>>> -- >>>> You received this message because you are subscribed to the Google Groups >>>> "MacVisionaries" group. >>>> To unsubscribe from this group and stop receiving emails from it, send an >>>> email to macvisionaries+unsubscr...@googlegroups.com >>>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>>> To post to this group, send email to macvisionaries@googlegroups.com >>>> <mailto:macvisionaries@googlegroups.com>. >>>> Visit this group at http://groups.google.com/group/macvisionaries >>>> <http://groups.google.com/group/macvisionaries>. >>>> For more options, visit https://groups.google.com/d/optout >>>> <https://groups.google.com/d/optout>. >>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to macvisionaries+unsubscr...@googlegroups.com >>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>> To post to this group, send email to macvisionaries@googlegroups.com >>> <mailto:macvisionaries@googlegroups.com>. >>> Visit this group at http://groups.google.com/group/macvisionaries >>> <http://groups.google.com/group/macvisionaries>. >>> For more options, visit https://groups.google.com/d/optout >>> <https://groups.google.com/d/optout>. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to macvisionaries+unsubscr...@googlegroups.com >> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >> To post to this group, send email to macvisionaries@googlegroups.com >> <mailto:macvisionaries@googlegroups.com>. >> Visit this group at http://groups.google.com/group/macvisionaries >> <http://groups.google.com/group/macvisionaries>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. > -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
