How do I check for duplicates within several columns and check a box

Hi All,

I'm making a grid for staffing events. Basically each event can have up to 3 staff members. I want a formula that will check for if there are multiple events on the same date and if a staff member is accidentally double booked. If they are double booked, to check the checkbox so I can run some conditional formatting. I've attached an example spreadsheet below.

What would my formula look like to check the "Double Booked" box?




Best Answer


  • Thanks so much Jason, this clears up some things I did have to change the greater than 3 to 4 to make this work but it did!

  • Jason now I got most of it to work, but how can I get that formula to ignore blank staffing cells in each column?