From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Use three methods to identify and count empty cells

Use three methods to identify and count empty cells - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Use three methods to identify and count empty cells

“

- Let's have some fun with this. We need three different ways to count the empty cells. The Last Name column has empty cells, okay. Ardiss doesn't have a last name. Sly doesn't have a last name. So use one way to count the blanks in the Last Name column, and then another way to count the empty cells in the Start Date column, and then a third way to get the empty cells in the Program column. Scroll down, look at the data. Okay, so it's not that much data, but please, think make your solution as simple and elegant or as wild and messy as you want it to be. The idea here is to just think about how to do one thing, several different ways. All right, now it's your turn. Pause the video, get those counts, then come on back. (pause music) Welcome back! Let's do it. I want to put my cursor in the data set, Format as Table. Let's get something fun. How about this blue? Okay, and then get rid of these filter…

Contents