 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008Find row referenced by a formula
Hello this is going to sound like a lame question but I was wondering is there is a way to get the row from a formula. For example I am using the large formula to find the second largest value in a range, I would like to be able to find the row of the value that the large formula returns. Is there anyway to do this. Thanks. Suppose the range is A3:A8 and the LARGE formula is in B3. Then =MATCH(B3,A3:A8,0)+ROW(A3)-1 would give the row number in col A of the value in B3. Hth, Merjet > Suppose the range is A3:A8 and the LARGE formula is in B3. > Then =MATCH(B3,A3:A8,0)+ROW(A3)-1 would give the row [quoted text clipped - 4 lines] > > Thank. I just tried it and it worked like a charm. Thanks a million merjet your great. > Suppose the range is A3:A8 and the LARGE formula is in B3. > Then =MATCH(B3,A3:A8,0)+ROW(A3)-1 would give the row [quoted text clipped - 4 lines] > >Sorry to ask another dumb question but is there anyway to create a cell reference using that row value. Example. Once I get the row number I want to create a formula in a cell that takes the row value to reference a cell. =A(row value) or =B(Row value) . Thanks again for all your help. >Sorry to ask another dumb question but is there anyway >to create a cell reference using that row value. Example. >Once I get the row number I want to create a formula in a >cell that takes the row value to reference a cell. >=A(row value) or =B(Row value) . Sorry; that's not clear to me. Maybe a more specific example would help. Merjet Sorry. After finding which row holds the greatest value I would like to create another formula that can pull more information using that row value. I was wondering if there is a way to concatenate a column letter with the row value inside of a formula. Example. using your Match formula we find that the row with the greatest value is row 4. I would like to create a formula that looks at that value and uses that row number to pull more information from that row. The column may change but the row referenced will be the value that the Match formula found. I am sorry about how confusing this is but it is kind of hard to explain. Thanks. > >Sorry to ask another dumb question but is there anyway > >to create a cell reference using that row value. Example. [quoted text clipped - 6 lines] > > Merjet It's still not clear to me. But have a look at the INDEX formula. It may help each your goal. Hth, Merjet |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.