Results 1 to 26 of 26

Limit data entry with Data valitadtion based on date

Threaded View

  1. #1
    Registered User
    Join Date
    05-14-2009
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    50

    Limit data entry with Data valitadtion based on date

    I thought that I had the answer to this earlier from one of the forum contributers and I closed out the question, but of course the user has changed the requirements, and I can't get the code to change to what I need now.

    I need to have datavalidation apply to a range of cells (J9:j139) where it checks to see if the previous cell in the range holds an "F" or an "H" then limit the entry accordingly based on the date field for that row:
    • The use of the "H" value can only be used once per day, and no other "H" or "F" values can be added for that date
    • The use of "F" can have multiple rows for the same date
    I also need to be able to count unique "F" days and "H" days The "H" days are easy [=COUNTIF(J11:K139,"H")] once I have the data validation properly set, but the "F" days are stumping me.
    Attached Files Attached Files
    Last edited by Phraedrique; 01-24-2012 at 06:35 PM. Reason: Spelling / typo corrections.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1