Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Oh I see, I was thinking if you entered a state then 1 or 0 would show up but if you enter 1 a list of states with the value 1 will apear... Here is a very similar post from a few months ago, asking for the same thing, with a detailed explaination from Max, you could use the autofilter as well... http://tinyurl.com/ovyf3 -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=537588 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
Can I format a cell in excel based on a list of about 20 items? | Excel Discussion (Misc queries) | |||
List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions |