1:1 as the Array using the MATCH function Knot2Brite 07.07.2006 19:52:01 Hello, I am working on an Excel course from OzGrid. One of the problem/examples defines the MATCH function Array as 1:1. In my ignorance I expected something like A1:G50. I can't find in Help an explanation of what "1:1" defines. I will appreciate some guidance. Thanks Bob

RE: 1:1 as the Array using the MATCH function Ron Coderre 07.07.2006 20:09:02 The 1:1 in the array indicates ALL of Row_1. Does that help? *********** Regards, Ron XL2002, WinXP "Knot2Brite" wrote: [Quoted Text] > Hello, > > I am working on an Excel course from OzGrid. > > One of the problem/examples defines the MATCH function Array as 1:1. In my > ignorance I expected something like A1:G50. > > I can't find in Help an explanation of what "1:1" defines. I will > appreciate some guidance. > > Thanks > > Bob > >

RE: 1:1 as the Array using the MATCH function Knot2Brite 07.07.2006 20:17:02 Hello Ron, Thank you. With this bit of information the lesson makes sense. Are there things like "1:2" or "2:2" or "2:1" that I should be alert to? Thanks again, Bob "Ron Coderre" wrote: [Quoted Text] > The 1:1 in the array indicates ALL of Row_1. > > Does that help? > *********** > Regards, > Ron > > XL2002, WinXP > > > "Knot2Brite" wrote: > > > Hello, > > > > I am working on an Excel course from OzGrid. > > > > One of the problem/examples defines the MATCH function Array as 1:1. In my > > ignorance I expected something like A1:G50. > > > > I can't find in Help an explanation of what "1:1" defines. I will > > appreciate some guidance. > > > > Thanks > > > > Bob > > > >

RE: 1:1 as the Array using the MATCH function Ron Coderre 07.07.2006 20:50:01 Yes.... In a blank cell, type =SUM( Experiment with this: Select one or more entire column(s) or row(s) and see how the formula changes to reflect the selections. Example: If you selected columns E through G, the formula will display: =SUM(E:G Does that help? *********** Regards, Ron XL2002, WinXP "Knot2Brite" wrote: [Quoted Text] > Hello, > > I am working on an Excel course from OzGrid. > > One of the problem/examples defines the MATCH function Array as 1:1. In my > ignorance I expected something like A1:G50. > > I can't find in Help an explanation of what "1:1" defines. I will > appreciate some guidance. > > Thanks > > Bob > >

Re: 1:1 as the Array using the MATCH function "Bob Phillips" <bob.NGs[ at ]somewhere.com> 08.07.2006 09:31:25 1:2 is simply two rows, 1 and 2, 2:2 is row 2. It is unlikely that you will see 2:1 as Excel will change it to 1:2. I do recall an instance where Excel didn't convert it, I cannot remember where now, but it still treated it the same. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Knot2Brite" <Knot2Brite[ at ]discussions.microsoft.com> wrote in message news:751BF6C6-6A53-4EE3-AF63-2CDD30E97316[ at ]microsoft.com... [Quoted Text] > Hello Ron, > > Thank you. With this bit of information the lesson makes sense. > > Are there things like "1:2" or "2:2" or "2:1" that I should be alert to? > > Thanks again, > > Bob > > "Ron Coderre" wrote: > > > The 1:1 in the array indicates ALL of Row_1. > > > > Does that help? > > *********** > > Regards, > > Ron > > > > XL2002, WinXP > > > > > > "Knot2Brite" wrote: > > > > > Hello, > > > > > > I am working on an Excel course from OzGrid. > > > > > > One of the problem/examples defines the MATCH function Array as 1:1. In my > > > ignorance I expected something like A1:G50. > > > > > > I can't find in Help an explanation of what "1:1" defines. I will > > > appreciate some guidance. > > > > > > Thanks > > > > > > Bob > > > > > >