Please see attached workbook.
I would like to create a dropdown list that only contains only the names in the first column that correlate to a "P" in the second column of the table.
The table will have rows added to it regularly and the dropdown list should update automatically.
I feel like this may be very easy, but I simply cannot figure out the data validation.forum.ozgrid.com/index.php?attachment/72483/