| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defined named range (Array list)
Hi,
I have a defined name 'ActivityList' with refer to: ={"Basic","Prime"...................."} and so on with move than 13 to 15 entries upto 30+ which keep on updating. Basically using it with sumproduct formula. =SUMPRODUCT(--(ActivityList=$B$25),(AMTList)+(DiscountList),-- (DateList=O$5)) The problem I'm having is that it does not allow more than 13 to 15 entries. Any work around would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA defined named range not appearing in Names list... | Excel Programming | |||
| Reviewing a list of defined named ranges | Excel Programming | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| Passing a named range into a user defined function | Excel Programming | |||
| Defined named range to array | Excel Programming | |||
Threaded Mode
