|
|
#22
09-26-2018, 10:38 PM
|
|||
|
|||
In my previous posting, at end of it I explained, how to use dynamic Named Ranges to do what you want!
In attachment I redesigned your named ranges, and your formulas started work in way you did want. Additionally I added another range which includes data from both columns, and a couple of columns using this range as example. 
|
| Tags |
| named ranges |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Named Ranges Help
|
SavGDK | Excel | 5 | 05-01-2017 09:41 AM |
|
Data Validation List based on Two Named Ranges
|
Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |
| How to use named ranges in excel vba? | bosve73 | Excel Programming | 4 | 01-25-2012 09:26 AM |
| Dynamic Named Ranges using text | hannu | Excel | 0 | 06-22-2010 04:42 PM |
| Can't import home adresses in outlook 2010 from excel named ranges | eekie | Outlook | 0 | 05-14-2010 02:04 PM |
Windows 8 
Office 2016
Threaded Mode