From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Sort moons

Sort moons - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Sort moons

“

- Let's do some custom sorting. In column B, we have a list of moons and their associated planets. Ariel is a moon of Uranus, Ganymede is a moon of Jupiter. The objective for today, create a column for planets, a column for moons, and then sort the moons, first by the planet's distance from the sun, and A to Z. Therefore, all of Saturn's moons should be together and sorted within that group alphabetically. But Saturn's moons need to be after Jupiter's moons and before the moons of Uranus. Got that? We're doing some custom sorting, folks. Pause the video, custom sort, then come back. Okay, let's slide some things out of the way so that we can get going. I'm going to insert a couple of columns there. Alright, so I want equals, text split, double click, split this text, comma, what's the delimiter? End double quotes. Space-Space, double quote and enter. We got 'em separated. Drag this down. Next I'm going to…

Contents