Enders Game: Location of a number

  • Thread starter Thread starter Rambo
  • Start date Start date
R

Rambo

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
 
=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
 
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.
 
Back
Top