| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using dcount on a variable data range
I want to use dcount on a data range, but the number of rows of data will
vary depending on a calculated value elsewhere in the S/S. Is there any way of dealing with this without going into VB programming? I can record a macro but cannot write them from scratch |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using dcount on a variable data range
You may use dynamic named ranges. There are some examples at:
http://www.ozgrid.com/Excel/DynamicRanges.htm Hope this helps, Miguel. "JohnJC" wrote: I want to use dcount on a data range, but the number of rows of data will vary depending on a calculated value elsewhere in the S/S. Is there any way of dealing with this without going into VB programming? I can record a macro but cannot write them from scratch |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set the pivot table to auto-update the data range? | Excel Discussion (Misc queries) | |||
| Add a data series dynamically to a named range? | Charts and Charting in Excel | |||
| Data Validation range | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
