Excel Help: Creating drop down list

[trance]

So basically:

Drop down selectables: Bank, Home, Personal

Bank: 1,2,3,4,5
Home: A,B,C,D
Personal: new,old,medium

So when any of the a title is chosen in the drop down list, it displays all of the values for it down teh column.

Ex. If I chose Bank from the drop list this would happen:

1
2
3
4
5

or maybe if I choose Home:

A
B
C


Yes, I'm a n00b thats why I need help!

Moved from OT
Anandtech Moderator - bsobel

 

[HomeBrewerDude]

just use Excel help and look for drop down menus!

Then just use nested IF statements to do the rest.

 

[Xavier434]

This belongs in the programming forums. You'll get the response you need there.

 

[imported_griffis]

You can google this, its actually quite easy.

 

[trance]

I've tried to no avail. I can't find any examples of making the entire list appear when selected from the drop list.

 

[z0mb13]

yep, drop down menu is the answer

 

[trance]

Simply dropdown only returns 1 value rather then the entire list. 🙁

 

[glutenberg]

Go to your top toolbar. Select Data --> Filter --> AutoFilter. Do an excel help search for AutoFilter for advice on how to use it.

 

[glutenberg]

Originally posted by: trance
Simply dropdown only returns 1 value rather then the entire list. 🙁

Did you need it to display only that specified category?

 

[trance]

W000t, Thanks glutenberg. It worked. It went to CUSTOM and then EQUAL. Now all values with the same column values are returned to the list!😀

 

[NeoV]

data-validation - list also enables things like this