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

Posted on April 26th, 2017 in 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.

Leave a Reply