Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If I have an array formula something like this:
=SUM(1*(BA20<$BA$19:$BA$755)) Is there a way to obtain a reference to a specific column in a named range and use that instead of hardcoding the column range? I'm thinking of something like this (which I know is wrong but should illustrate what I'm trying to do): =SUM(1*(BA20<NamedRange.Column(3))) Is this sort of thing doable? Thanks. ------------------------------------------------------------- Kel Good MCT, MCAD, MCSD for Microsoft.NET |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Named Range within an Array Formula | Excel Discussion (Misc queries) | |||
count(if(... using array formula: can I use a named range in my ca | Excel Worksheet Functions | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
Using a formula to create named range reference | Excel Worksheet Functions | |||
Setting named range in VBA- how to set as formula/reference instead of text string? | Excel Programming |