Conditional Lists....You want a challenge don't you? :)

[Roccofan]

I've tried searching the archived messages and I can't find something close enough to what I need to be useful.

What I'm tring to do is have a list (validation or otherwise) that changes with the selections made in other lists. For example:

Column A = a list of firms..Lehman, Goldman, FBR, FBW

Column B = Account numbers for those firms....4568,5287,368514,1234,68547

Column C = Stocks or bonds associated with each account.....Nike,FannieMae,Dell,Gateway,BN

Column A and B will repeat each time a security is added, so even though there are five firms, they will repeat in the column and might not be in order.

I want to have three drop down boxes (validation or otherwise) The first will allow for the selection of "uniquie" firms in the list of firms that repeats. The Second will allow for the selection of account numbers associated with the firm selected in the first box. The third will allow for the selection of a stock/bond associated with the account number in the second box.

I'm investigating the use of OFFSET in the validation source.


Thanks.
RF

 

[Juan Pablo González]

How about a Pivot Table ?

Otherwise, depending on how your data is setup, you could use this:

http://www.mrexcel.com/board/viewtopic.php?topic=40&forum=2

 

[Aladin Akyurek]

See:

http://www.mrexcel.com/board/viewtopic.php?topic=40&forum=2

 

[Juan Pablo González]

On 2002-09-27 08:39, Aladin Akyurek wrote:

See:

http://www.mrexcel.com/board/viewtopic.php?topic=40&forum=2

That's an old topic, isn't it Aladin ?

 

[Roccofan]

Thanks for the suggestions guys, but I've already looked at those posts and they aren't what I need.

I guess I want more than Excel can deliver right now. It might be that I need to bite the bullet and have my data arranged differently.

Any other ideas would be greatly appreciated. Let me know if you want the requested stated differently.

RF

 

[Juan Pablo González]

How about some sample data then ? and along with the expected results...

 

[Roccofan]

On 2002-09-27 09:40, Juan Pablo G. wrote:
How about some sample data then ? and along with the expected results...

How do I insert the data into the post using an Excel screen shot. I've seen a number of posters use it, but I don't know how.

 

[Aladin Akyurek]

[...]I've already looked at those posts and they aren't what I need.

Is that because of "repeats" in the first list?

 

[Roccofan]

Is that because of "repeats" in the first list?

That's correct, none of the posts I've seen address the possibility of list that only displays unique entries in a column. Outside of a Pivot Table and a filter, I haven't seen this done.

 

[Aladin Akyurek]

On 2002-09-27 10:38, Roccofan wrote:

Is that because of "repeats" in the first list?

That's correct, none of the posts I've seen address the possibility of list that only displays unique entries in a column. Outside of a Pivot Table and a filter, I haven't seen this done.

Really? How about using a method described in

http://www.mrexcel.com/board/viewtopic.php?topic=8659&forum=2

to build (dynamically) the needed lists of unique items that you can invoke as source(s) in data validation?

Another old topic, by the way...
This message was edited by Aladin Akyurek on 2002-09-27 11:06