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

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