Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Please Help: Adding an equation to a range
Is it possible to add an equation to a range of data? For example, I am using the MATCH function to return the row number of a last value in a specific column. =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data' !E:E,0) I would like to use this row number to establish a named range that will adjust as a given set of data changes. For example, if the formula returned 100, I need the named range to be A1 to K100. Any different methods or suggestions? -- tobriant ------------------------------------------------------------------------ tobriant's Profile: http://www.excelforum.com/member.php...o&userid=25155 View this thread: http://www.excelforum.com/showthread...hreadid=399140 |
#2
|
|||
|
|||
Let's say you want to sum A1:K100 and the cell that returns 100 is L2, you can try: SUM(A1:INDIRECT("K"&L2)) Hope it helps. tobriant Wrote: Is it possible to add an equation to a range of data? For example, I am using the MATCH function to return the row number of a last value in a specific column. =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data' !E:E,0) I would like to use this row number to establish a named range that will adjust as a given set of data changes. For example, if the formula returned 100, I need the named range to be A1 to K100. Any different methods or suggestions? -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=399140 |
#3
|
|||
|
|||
Check out Debra Dalgleish's web page on this subject:
http://www.contextures.com/xlNames01.html#Dynamic -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "tobriant" wrote in message ... Is it possible to add an equation to a range of data? For example, I am using the MATCH function to return the row number of a last value in a specific column. =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data' !E:E,0) I would like to use this row number to establish a named range that will adjust as a given set of data changes. For example, if the formula returned 100, I need the named range to be A1 to K100. Any different methods or suggestions? -- tobriant ------------------------------------------------------------------------ tobriant's Profile: http://www.excelforum.com/member.php...o&userid=25155 View this thread: http://www.excelforum.com/showthread...hreadid=399140 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
adding range names | Excel Discussion (Misc queries) | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
Adding to a range in a reference? | New Users to Excel |