Trying to build list based on cell value

J

JWHart001

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
 
J

JWHart001

I'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.

John
 
J

JWHart001

It 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.
 
D

davesexcel

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
 
Top