From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Create an index column

Create an index column - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Create an index column

“

- [Instructor] We've got a list of names that we want to break down into groups. So what we want to do is in column B, that Index column, we want to list numbers 1, 2, 3, 4, 5 and then have that repeat all the way down. So we want 1, 2, 3, 4, 5, 1, 2, 3, 4, 5 like that, all the way to the end of the Names list. And then grab all of the people in Group 4 and put them in column G, all right? And do not type these one at a time. I'll know if you did and I'll come get you, all right? So pause the video, make this happen, come back, and we'll do it together. All right, you're back. Here's how this is done. So I'm going to type 1, 2, 3, 4, 5. Now, highlight here, and then I'm going to hold down the ctrl key. Look at that. It repeats, easy. All right, next, how am I going to get the 4s extracted? There's a lot of ways that we can do that. So how about this way? Let's go to data, and then I'm going to sort, and now there…

Contents