| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Defined range problem
The following formula is used as a defined range:
=OFFSET(Centre!C$77,0,0,COUNTA(Centre!$C77:$C65536 ),1)) What I have difficulty with is that the formula does not ignore cells that contain a formula which do not contain any data. Data ends in C807 but the formula continues on to C1000. What change can be made to the defined range so that it ignores a formula and just recognise a value? Hope someone will be able to point me the right direction. Many thanks. Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| Defined range difficulty | Excel Discussion (Misc queries) | |||
| Dynamic Range Problem | Excel Discussion (Misc queries) | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| HTML_Control Range name | Excel Discussion (Misc queries) | |||
Threaded Mode
