LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
davesexcel
 
Posts: n/a
Default Trying to build list based on cell value


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Change List Based on Value Chosen in Another List Edwin Kelly Excel Worksheet Functions 4 March 2nd 06 07:31 PM
display a drop-down list based on the content of another cell Joe S Excel Discussion (Misc queries) 6 December 6th 05 12:23 AM
How can I populate an Excel cell based on the data in another cell JerseyBoy Excel Worksheet Functions 3 September 30th 05 03:53 PM
Can I format a cell in excel based on a list of about 20 items? arkansooner Excel Discussion (Misc queries) 1 June 17th 05 02:38 PM
List ? - How do I make information in one cell determine list to u Brad_A Excel Worksheet Functions 1 January 18th 05 04:10 PM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"