Re: Finding a duplicate entry with no end date

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Tried it again - and worked perfectly. Thanks so much for your help. J

"Max" wrote:

"Janelle S" wrote:
Thanks Max. One small problem - the error alert pops up if there is an end
date - I want it to pop up if there is no end date. Any suggestions??

That shouldn't be. Perhaps you implemented it incorrectly? Pl try it again.
It should work properly as per your specs, ie the error alert will pop up if
the name entered is a duplicate, and if there is *no* end date (I've just
retested it again here)

Remember it was assumed that end dates are in col C, in C2 down

Take a moment to press the "Yes" button from where you're reading this
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
.

Relevant Pages

  • Re: Finding a duplicate entry with no end date
    ... "Janelle S" wrote: ... the name entered is a duplicate, and if there is *no* end date (I've just ... Take a moment to press the "Yes" button from where you're reading this ...
    (microsoft.public.excel.misc)
  • Re: Help with Array Usage
    ... Part of the solution to your problem will then be opening a file for reading. ... There are no numbers at all in the first column. ... How can I remove duplicate elements from a list or array? ... Part of the solution to your problem will then be appending ...
    (comp.lang.perl.misc)
  • Re: How do I copy first consonant from a word into new cell
    ... When I run the code, the debugger stops on the last item saying it is a duplicate key, so it appears to have accepted the one million characters long keys and is apparently using them correctly. ... solutions is important, though, both for those reading this thread now, and ... nothing to do with Excel other than the solution is VBA. ...
    (microsoft.public.excel.misc)
  • Re: Problem in Win32Forth with open-file
    ... Win32Forth rev 6.10.04. ... I can open a file ok for reading, ... name is not a duplicate of an existing file and I can create the ... DOH! ...
    (comp.lang.forth)
  • Re: Problem in Win32Forth with open-file
    ... Win32Forth rev 6.10.04. ... I can open a file ok for reading, ... name is not a duplicate of an existing file and I can create the ... George Hubert ...
    (comp.lang.forth)