Help! Countif codes..
Results 1 to 2 of 2

Thread: Help! Countif codes..
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help! Countif codes..

    Good Day Mam/Sir.

    In this project , i have to register for an appointment.
    Sample picture below.



    as of now, i am managing to save the inputs from userform to worksheet.
    to finish my project, i just want to add a code that limit the applicant to register for a specific time in a specific date.

    here is the scenario:
    I am registering for an appointment.
    I will enter my name, choose what date and what time.
    (example picture above)

    Now i want to limit the applicant that can register in a specific time and date.
    for example max 10 applicants can register on 8-10am, Nov.8,2019.
    if that time and date reaches the limit, i want to make that option under the combobox "8am - 10pm" cannot be chosen anymore coz it reaches 10applicants. (Hope you get what i am trying to attain here).

    Is it possible to do that?
    Please help me write a code, for now i am studying COUNTIFS in youtube tutorials but unfortunately cant write a code.

    Help is so much appreciated.
    again, forgive me because i am only a newbie, only relying on youtube tuts.

    THANK YOU! AND GOD BLESS!

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,083
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Help! Countif codes..

    FYI

    You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

    https://www.mrexcel.com/forum/about-...tachments.html

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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