Pivot Sorting - 1059 - Learn Excel from MrExcel

Lisa from Chicago sends in today's question. Why can't you sort the page field in a pivot table? Episode 1059 talks about several ways to sort the row fields in a pivot table and then a method for sorting the filter field.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

No-Header Sort - 1051 - Learn Excel from MrExcel Podcast

Jeffrey wonders why the top row of his data won’t sort. He has a blank row between the data and the headers, which looks great, but is fooling the Intellisense. Episode 1051 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

2nd Smallest - 1037 - Learn Excel from MrExcel Podcast

If you need to find the smallest value in a range, you would use MIN. Episode 1037 will show you how to find the second smallest value, third largest value and so on. Also in this episode, sort with a formula.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Dueling: Sort with a Formula - 1025 - Learn Excel from MrExcel Podcast

A dueling Excel podcast where Mike and Bill take a look at how to sort using a formula. While most people would use RANK and COUNTIF, Episode 1025 shows you how to use LARGE and ROW or ROWS.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #982 - Sequence Column

Mike Girvin wonders why Joe from Episode 977 doesn't just sort the data so that all the filtered records are together? You can do this if you use an Original Sequence column so that you can sort back. Episode 982 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #962 - Sorting Left to Right

One of the requests from last Friday's podcast was the ability to sort columns like you can sort rows. It's in there! In Episode 962, I will show you how to sort left to right.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #951 - EOMonth Sorting Word

Jamie shows how to use EOMonth to find the first of next month and Melanie shows how to sort paragraphs in Word. Episode 951 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #949 - Grouping Ages

Steve asks how to group records into age ranges. In Episode 949, I show how to use the range version of VLOOKUP to solve this problem.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #948 - Reverse Chart Axis

Create a bar chart from a pivot table. If you sort the pivot table into ascending sequence, the chart sorts into descending sequence. Episode 948 will show you the obscure solution to this problem.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #940 - Sort Pictures with Data

Steve wants to know how to sort pictures with the associated data. There is an obscure setting that controls if pictures sort with the cells or not. Episode 940 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 852 - Tiny Blank Columns

Sometimes a manager demands that you insert tiny little columns between the columns of your data set. While I hate this, use the trick in Episode 852 to ensure that the data set sorts correctly.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 755 - Sort Largest

You need to sort a detailed data set so that the records for the largest customer are at the top. Episode 755 will show you a quick way to accomplish this task.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 708 - Pivot Sorting

Episode 708 shows how Excel offers sorting rules that allow your pivot tables to be sorted in a certain manner. The old AutoSort option is now hidden behind a dropdown in the pivot table field list.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 704 - Deleting Blank Rows

In today's podcast, a simple process to delete the blank rows by sorting the data first. Episode 704 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 544 - Rearranging all Columns

In yesterday’s podcast, I showed how to rearrange one column. But – what if you need to rearrange all of the columns? Episode 544 shows how to use a little known sorting trick to sort the columns back to the original sequence.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 535 - Sorting by Month

Mario writes in with a comment about Episode 507 on sorting text that looks like dates. No need to jump thru hoops to convert the data. In Episode 535 Mario suggests an easier way to sort by month.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 520 - Custom Sort

Sometimes, your company tradition will force you to sort into neither ascending or descending sequence. Episode 520 shows you how to set up a custom sort in Excel 2003 or Excel 2007.

This blog is the video podcast companion to the book, Learn Excel from MrExcel and Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the books!

Episode 519 - Center Sorting

George has a dataset today where a serial number contains 3 groups of digits in a single column. George needs to be able to sort by the middle group of digits. Episode 519 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 406 - Color Sort

New in Excel 2007 - you can sort by cell color! Today's episode takes a look at the new Sort dialog in Excel 2007. You can sort by more than three levels, and also choose to sort by font color, cell color, or icon. Episode 406 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Episode 395 - Parsing Text

In today's episode a caller asks how to split names that are in one cell into first name in column A and last name in column B. Episode 395 shows how to do this trick, but then the annoying gotcha that will happen for the rest of the day.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!