View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Trying to build list based on cell value

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