Excel - Using Descriptive Statistics with Rectangular Ranges | Dueling Excel - Episode 1010
1,422 views · Published 8 May 2009 · 5:53 · Indexed 12 November 2026
Channel: MrExcel.com · 2009 · Education
Microsoft Excel Tutorial: Using Descriptive Statistics with Rectangular Ranges. Welcome to another episode of the Dueling Excel podcast! In this video, Mike Girvin from Excel Is Fun and I, Bill Jelen from MrExcel.com, will be sharing some valuable Excel tips and tricks with you. Today, we will be discussing a common issue faced by many Excel users - how to use the Analysis Tool Pack's Descriptive Statistics feature when the data is not in a single column or row. Our viewer, Gary, has asked us how to use this feature when the data is in a rectangular range. He wants to know how to "unwind" the data into a single column or row. Mike will be showing you his solution, and I will be sharing a macro solution. So, let's get started! Before we dive into the solutions, let's take a quick look at the Analysis Tool Pack and how to enable it. You can find it under the Data tab, but you may need to enable it first. To do so, go to the Office button and select Options. Then, go to Add-ins and select Analysis Tool Pack. This will add the feature to your Data tab. In earlier versions of Excel, it will also add some extra functions for you. Now, let's move on to the solutions. Mike will be showing you a trick using the clipboard, while I will be using VBA to solve this issue. Mike's trick involves copying and pasting the data in a specific way, while my solution uses a simple macro. We will both demonstrate how to use these solutions step by step, so you can easily follow along and apply them to your own data. We hope you find these tips helpful and that they save you time and frustration in your Excel work. Don't forget to subscribe to our channels for more Excel tips and tricks, and let us know in the comments if you have any other Excel questions or challenges you would like us to address in future videos. Thanks for watching, and we'll see you in the next Dueling Excel podcast! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ A dueling podcast: how to unwind a rectangular selection to a single column. Mike & Bill weigh in with differing methods in Episode 1010. 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! Table of Contents: (00:00) Introduction by Bill Jelen and Mike Girvin (00:25) Question from Gary about using the analysis Tool pack (00:35) Gary's question about copying and pasting data (00:48) Mike's solution using the clipboard and data analysis feature (03:46) MrExcel's solution using VBA (05:33) Clicking Like really helps the algorithm This video answers these common search terms: Analysis Tool pack Clipboard trick Copy and paste special Data analysis in Excel Descriptive statistics Excel tips Macro solution Personal macro workbook Shortcut keys in Excel Statistics in Excel Unwind data VBA code Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152397/ #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:37
Excel - Enhance Your Excel Charts: Add a Picture as a Background in Excel - Episode 917
-
2:00
Excel Hiding Data in Plain Site - Episode 919