View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janelle S[_2_] Janelle S[_2_] is offline
external usenet poster
 
Posts: 26
Default Finding a duplicate entry with no end date

Hi all
Hoping you can help out? I have a list of names with start and end date (of
placement). When I enter a new entry I want to be able to identify if a
previous entry does not have an end date and then a warning pops up for the
user saying something like "another placement still current".
Thanks in anticipation.