#16
|
|||
|
|||
See the attached.
You might also want to study Excel implicit intersection |
#17
|
|||
|
|||
I'm sorry, but I do not understand.
In other tables, I have used an explicit intersection. In that case, I used "name from selection" for the entire table and named ranges were created for each row and each column. Then I used an "intersection" reference for whatever cell I wanted to access. Please explain how(if) an implicit intersection. |
#18
|
|||
|
|||
I also do not understand (what you write in your second sentence).
I regret, but I think it is time for me to stop. |
#19
|
|||
|
|||
xor, I must be going bonkers, but when I read your 11:01 post, all I saw was "implicit intersection" with no file attached.
Anyway, I appreciate your efforts, but you seem to be using a table as well. Now, at least I know what I was doing is called "implicit intersection" and I will be able to research it further. Thank you. |
#20
|
|||
|
|||
I am not using a table. See how col.1 and col.2 in file Mary_4 are defined.
Try to convert A1:F13 to a range and see that it doesn't change anything in columns I and J. |
#21
|
|||
|
|||
UPDATE: with xor's suggestion, I researched implicit intersection. The answer was not to be found there. However, I was able to use explicit intersection because my non-table was already set with named ranges for columns and rows.
This would have been some work had I not already it set up this way. So, thanks again, xor. |
#22
|
|||
|
|||
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. |
#23
|
|||
|
|||
Arvilaanemets,
I just tried the dynamic range as you showed previously and I worked great. and xor, You did dynamic ranges as well. I am sorry I misread your instructions. Just out of curiosity...Most descriptions of how to do dynamic ranges use offset or index. Your way is so much easier. Maybe I just missed this in my searches. Thank you both. |
#24
|
|||
|
|||
Oh boy,
First he giveth then he taketh away. The dynamic named ranges worked well on their own (first) sheet. However, from a different (second) sheet I had been using an explicit intersection to pull from the first sheet. Now, these values on the second sheet are all "null." |
#25
|
|||
|
|||
Quote:
Quote:
|
#26
|
|||
|
|||
I created named-ranges for the same columns, but this time non-dynamically and they worked as before.
I may be creating more work by needing two names for each column than I am saving. But I am very glad to know that this is available. Thank you for your help. |
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 |