Determining row number in which a value occurs
 

Hello,

If I have an Excel 2007 spreadsheet containing a column of numbers which are
sorted according to magnitude. I want to determine which row a specified
value occurs in, how do I do this? The value to be found is contained in a
user-entry cell and is a Named variable. Is there a way to do this with the
ROW function? If I for example assign the value the Name of "Sales" and refer
to the cell where it is stored, how do I seek that value in my column of data
and report the row number in which it occurs?

Thanks,
Harold

Determining row number in which a value occurs
 

Hi,
Is this any help?
Assuming your column of figures is in column A, with a heading in A1, and
the number you wish to find is in B2, then enter =MATCH(B2,A:A,0) in C2
should give you it's row number.Add or subract from the formula to adjust if
you have more or fewer heading rows.

Dave

"Harold Christian" wrote:

Hello,

If I have an Excel 2007 spreadsheet containing a column of numbers which are
sorted according to magnitude. I want to determine which row a specified
value occurs in, how do I do this? The value to be found is contained in a
user-entry cell and is a Named variable. Is there a way to do this with the
ROW function? If I for example assign the value the Name of "Sales" and refer
to the cell where it is stored, how do I seek that value in my column of data
and report the row number in which it occurs?

Thanks,
Harold