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.

Group and sort inventory items

Group and sort inventory items - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Group and sort inventory items

“

- [Instructor] You and I have a company, and we've got this list of all of our items, and they're listed alphabetically. We have to decide what to do with items that are being phased out and discontinued. It would be helpful to us if we could get this sorted discontinued items on the top and then phasing out items next, then underneath all of the normal items. But also within each group, sort the inventory number largest to smallest. Pause the video, get the list sorted, come back and I'll take you through a solution. Okay, you're back. Let's get this data sorted. I'm gonna click inside the data set and then go to data and then hit the sort icon. So we do initially wanna sort by item, but we want the discontinued items first. So we're gonna go to sort on cell color. On top, we want the discontinued items, which are orange. Next we wanna add a level. Sort by item again, sort on cell color, and then we want…

Contents