Results 1 to 4 of 4

Thread: Warning about duplicate entries
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2015
    Posts
    247
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Warning about duplicate entries

    Hi,

    I have a table that we use to help schedule employees and want some type of warning if we double book them. It is setup as such:
    A B C D E F G H I J K L M N
    1 Name Job# Loc 6/25 6/26 6/27 6/28 6/29 6/30 7/1 7/2 7/3 7/4 7/5
    2 John A X34 USA D D D D D D D D D
    3 Joe V45 CAN N N N N N N N N
    4 John A V45 CAN D D D D
    5 Jen X34 USA A A A A A A A A













    I would like some type of conditional formatting or an alert box to pop up if someone is double booked. From this example John A is double booked from 7/2 - 7/5. So if it has the same name and >=2 entries on the same date I would like some type of warning. I know some vba if that would provide an easier solution.

    Thanks!

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    23,863
    Post Thanks / Like
    Mentioned
    403 Post(s)
    Tagged
    42 Thread(s)

    Default Re: Warning about duplicate entries

    How using CF with this formula
    =COUNTIFS($A$2:$A$5,$A2,D$2:D$5,"<>")>1
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular
    Join Date
    Mar 2015
    Posts
    247
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Warning about duplicate entries

    Great! That worked perfectly!

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    23,863
    Post Thanks / Like
    Mentioned
    403 Post(s)
    Tagged
    42 Thread(s)

    Default Re: Warning about duplicate entries

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

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
  •