If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|