| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help With Dynamic Range
Hi There,
I am not sure if what I want can be done with a Dynamic Range. The formula below works great for capturing anything within the range that is "CCLS", however I now require the formula to look down ColumnA and ColumnI, and anything that matches "Actual" in ColumnA and anything that matches "CCLS" in columnI, highlight this range. tia Harry =OFFSET(SearchResults!$A$2,0,0,COUNTIF(SearchResul ts!$I:$I,"CCLS"),12) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WEEKNUM to dynamic range name | Excel Worksheet Functions | |||
| Can't chart dynamic named range?? | Charts and Charting in Excel | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Threaded Mode
