| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Dynamic Range
I created a dynamic named range(Daily_Postage) from data on
sheet1(Import_Postage) that basically includes only the rows that have data. Works good. Now I want to display that new set of data on sheet2 without spreading formulas around in each cell. Thought I could =OFFSET(Daily_Postage_Range,0,0,COUNTIF('Import_Po stage!$A$A,"0",12) in A1 and see the whole array on sheet2 but no. Help? Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range | Setting up and Configuration of Excel | |||
| Dynamic Time Display | Excel Worksheet Functions | |||
| Chart attached to dynamic range | Charts and Charting in Excel | |||
| Dynamic Print Range Help | Excel Worksheet Functions | |||
| Add a Dynamic Range with 2 Conditions Q | Excel Worksheet Functions | |||
Threaded Mode
