David Evans
Active Member
I've been absent for a long time. I trust the denizens of Chandoo.org are happy and healthy.
I want to create a Table of unique values from another Excel Table, so that I can use it as a source for a lookup.
e.g. from the dates in Table 1, I want to derive the unique values, sorted in newest to oldest, to be the source of a dropdown list. My thought is that I should create Table 2 as the repository for the Unique values. However, I suspect it can be done without creating the second table, but I'm not smart enough to do it!
All suggestions gratefully received.
I want to create a Table of unique values from another Excel Table, so that I can use it as a source for a lookup.
e.g. from the dates in Table 1, I want to derive the unique values, sorted in newest to oldest, to be the source of a dropdown list. My thought is that I should create Table 2 as the repository for the Unique values. However, I suspect it can be done without creating the second table, but I'm not smart enough to do it!
All suggestions gratefully received.