See Sports Fixtures at

http://www.geocities.com/excelmarksway



"brian m." wrote:

How can I create a drop down list from non-adjacent cells (redundant message
I know...sorry). I'm working on a tournament bracket and I would like to
only have to select two non-adjacent cells for my dropdown list rather than
the entire column worth of cells between the two. Is there perhaps a formula
that would exclude the emptly cells and only include in the dropdown list
those cells with names in them?
Thanks in advance