Posts tagged ‘Sorting’
Learn Excel – Sort by Columns: Podcast #1345
“This is the first time that I’ve ever tried this – and it works!”
PowerPivot 2010 – DAX Measures: Podcast #1327
DAX Measures and Custom Filtering in PowerPivot 2010
Dueling Excel – “Sort with a Formula”: Podcast #1308
Today Dueling Excel looks at RANK, VLOOKUP, COUNTIF, LARGE and more!
PowerPivot Calculated Columns: Podcast #1260
Calculated Columns in the PowerPivot 2010 Grid . . .
Excel In Depth “Filter by Selection”: Podcast #1239
Filter by Selection? Where is it!? “Filter by Selection: The Excel 2010 mystery revealed!”
Excel in Depth – Custom Sorting: Podcast #1238
Sort Excel items into a sequence that is neither AZ nor ZA. Read more on this topic…
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!
