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> 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.
