Enders Game: Location of a number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rambo - 17 Sep 2007 02:03 GMT

Hi,

I am trying to do something that i think is rather simple I just have
no idea how to do it.

What I am trying to do is locate the position of a number in a
particular column of numbers

For example if I have the column

20
13
15
11
22
33
18

and I am looking for the position of the number 11,
Is there a function that will tell me that it is the 4th number in the
column?

I know I could just count but the columns that I am working with are
big

Thanks.

Sincerely,
Rambo

Reply to this Message

Dave Peterson - 17 Sep 2007 02:14 GMT

=match(11,a:a,0)
will give you the row of the matching cell (if there is one) in column A.

or
=match(b1,a:a,0)
if B1 holds 11

> Hi,
>
[quoted text clipped - 25 lines]
> Sincerely,
> Rambo

Signature

Dave Peterson

Reply to this Message

Ragdyer - 17 Sep 2007 03:04 GMT

To add to what Dave said, you should take into consideration that Match() is
"relative".
Relative to the location *IN* the data range.

If your list was in A25 to A31,
=Match(11,A25:A31,0)
Would still return a 4, not the row number of 28.

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> =match(11,a:a,0)
> will give you the row of the matching cell (if there is one) in column A.
[quoted text clipped - 32 lines]
> > Sincerely,
> > Rambo

Reply to this Message

Rate this thread: