| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for named range
My data is:
cell a2=24/jun/2006 cell a3=01/jul/2006 column B(b2:b9) ------------------- 21/jun/2006 22/jun/2006 23/jun/2006 26/jun/2006 27/jun/2006 28/jun/2006 29/jun/2006 30/jun/2006 I would like name a range in col.B by looking date values from col A(a2:a3).As per my above data I want to name a range $b$4:$b$9.I am looking formula to define the range name,what should I write in 'refers to' box. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adjusting a formula cell range | Excel Discussion (Misc queries) | |||
| Need formula to lookup a named range | Excel Discussion (Misc queries) | |||
| Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Threaded Mode
