1:1 as the Array using the MATCH function

[Knot2Brite]

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

[Ron Coderre]

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

[Knot2Brite]

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

[Ron Coderre]

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:

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

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
> > >
> > >