Avoid Hiring Boo-boos with Excel – COUNTIFS for the win [video]

Excel Howtos , Learn Excel - 0 comments

Imagine you are head of human resources at Casual Contracting Co. Every month you hire a lot of temporary staff who spend 1-4 months with CCC before leaving. Sometimes you hire the same people again. Of late, you have noticed a strange process gap. You are paying same person two (or more) salaries.

This is because you are hiring a person for new temp role even before their current one ended. See below picture.


So how to avoid making such hiring boo-boos.

Simple, using Excel of course.

There are a few ways to handle this problem.

  • Using formulas to check if a person is hired twice in the same period
  • Using conditional formatting to highlight such hires
  • Using data validation to prevent such data entry

I made a video covering all these methods in detail. Check it out below or on Chandoo.org YouTube channel.

Download hiring boo-boos workbook

Click here to download the workbook showcased in the video. Play with various dates & names to test formulas, CF and data validation.

Avoid Excel Boo-boos, Show it who-da-boss

Learning few simple Excel best practices and techniques can save you a lot of time & money. So why wait, check out below links and become awesome in Excel.

While you are at this, subscribe to Chandoo.org YouTube channel. I have been uploading videos once a month. While this is not exactly a staggering pace, you are sure to be a rockstar at work if you just watch all the previous vids and stay tuned for more. Check it out.


Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

Leave a Reply

« »