Hello. Can anyone tell me how to create a validation list and not show blank
cells or duplicates? I thought this was the default behavior of validation
lists, but it doesn't seem to be the case. Im using Excel 2003 SP1. Thanks.