software

I have a list of states where certain phone services are offered. A row
includes the state name and a select cell that indicates whether the state is
included in a plan. If the cell has a number 1 it is included and if it has
a 0 it is not included.

I would like to build a dynamic list of states included in the plan as the
indicator is flipped from 0 to 1.

Any suggestions? Thank you for your help.

John


Learn Dynamic names herewww.contextures.com/xlNames01.html#Dynamic

Here you can learn VLOOKUP

www.contextures.com/xlFunctions02.html

you could have a 0 or 1 beside the list of states, whatever list you
used for your dropdown menu, the vlookup formula will correspond to it--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537588I'm not following your suggestion Dave, but it could be because I didn't
express my need well enough. Here is an example of the table I have:

State Select
Alabama 1
California 0
Oregon 1
Ohio 1
New Hampshire 0

I would like to create a list on another worksheet that just has those
states that were selected. It would look like:

Alabama
Oregon
Ohio

If your original recommendation will return this type of list, could you
please explain in more detail. I didn't see how at the site that you
originally sent me. Thank you Dave.

Johnquot;davesexcelquot; wrote:

gt;
gt; Learn Dynamic names here
gt;
gt;
gt; www.contextures.com/xlNames01.html#Dynamic
gt;
gt; Here you can learn VLOOKUP
gt;
gt; www.contextures.com/xlFunctions02.html
gt;
gt; you could have a 0 or 1 beside the list of states, whatever list you
gt; used for your dropdown menu, the vlookup formula will correspond to it
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=537588
gt;
gt;


will the 1 or 0 be in column a or b??--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537588It doesn't matter which column since it's the filtered list that is most
important. Also, because of certain inhouse restrictions, I need to do this
without writing a macro. Thank you again Dave.

quot;davesexcelquot; wrote:

gt;
gt; will the 1 or 0 be in column a or b??
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=537588
gt;
gt;


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...tinyurl.com/ovyf3--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537588