| 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 |
| 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 | |||
Threaded Mode
