Learn Excel from Bill Jelen with this daily 2 minute video 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.
posted by Bill at 9:00 AM
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.
posted by Bill at 9:00 AM
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.
Labels: Sorting
posted by Bill at 9:00 AM
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.
Labels: Sorting
posted by Bill at 9:00 AM
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.
Labels: EOMONTH, Microsoft Word, Sorting
posted by Bill at 9:00 AM
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.
posted by Bill at 9:00 AM
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.
Labels: axis, categories, chart, Sorting
posted by Bill at 9:00 AM
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.
posted by Bill at 9:00 AM
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.
Labels: Sorting
posted by Bill at 9:00 AM
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.
Labels: Sorting
posted by Bill at 9:00 AM
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.
Labels: Excel 2007, Pivot Table, Sorting
posted by Bill at 9:00 AM
In today's podcast, a simple process to delete the blank rows by sorting the data first. Episode 704 shows you how.
Labels: Sorting
posted by Bill at 9:00 AM
