Danny wants to enter a value and have all of the like values sort to the top of the list.One way to do this is to use the Filter in Excel 2010, but there are other ways to accomplish this task – and today, in Episode #1530, Bill shows us other methods…but maybe you have an awesome method to share!? To contact Bill with your method to accomplish this task you may email MrExcel [bill “at” mrexcel.com].


"Learn Excel 2007 through Excel 2010 from MrExcel" by Bill Jelen…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!