MrExcel Excel Videos

Dave wishes that Excel would offer a REPTARRAY function, just like REPT but for arrays. This video shows four different ways to repeat an array N times. Vote for Microsoft to add REPTARRAY: https://feedbackportal.microsoft.com/feedback/idea/0f6d6e22-7cb3-ed11-a81b-002248519701 Details about FastExcel: FastExcel V4 SpeedTools Here are the formulas used in the video: =TEXTSPLIT(REPT(TEXTJOIN(",",TRUE,A)&",",$E$1),,",",TRUE) =DROP(REDUCE("",SEQUENCE($E$1),LAMBDA(a,b,VSTACK(a,D))),1) =LET(a,E,rw,COUNTA(a),MAKEARRAY(rw*$E$1,1,LAMBDA(r,c,CHOOSEROWS(a,MOD(r-1,rw)+1)))) If you have FastExcel V4 from Charles Williams: =REPEAT(A2#,E1) If you have a better way, please post below in the YouTube comments. Excel Most Efficient Way to...

Microsoft Excel Tutorial Table of Contents (0:00) Random sample from Excel list? (0:03) Analysis ToolPak (0:07) Easier - Select 28 Rows (0:21) SORTBY RANDARRAY (0:44) No RANDARRAY? Use RAND

Excel Pivot Table - Total of Minimums - 2588 Microsoft Excel Tutorial on Pivot Tables. Illia K asks: "Hello, is it possible to sum min values column in grand total? If I choose sum in grand total it turn column in sum of values and I just need sum of min values. can you please help?" In this video, I show how the Grand Total of a column of Minimums is normally the Minimum value in the column. However, using a trick from Rob Collie and a Data Model Pivot Table with two DAX Measures, I manage to Sum the Minimums in the Grand Total. Here are the 12 steps needed to make this work: Steps: 1. Make into a Ctrl+T table 2. Name the data, such as BillData 3. Insert, Pivot Table, Data Model, Existing Sheet 4. Drag Sector to Rows 5. Right-click...

Microsoft Excel - Copying VBA Module from one workbook to another. John B has a workbook with a lot of data. He created a new workbook with a macro for testing. Now that the macro is working, he wants to copy the working macro from the test workbook to the workbook with all of his data. This video shows how to launch the VBA Editor with Alt F11 Display the Project Explorer. Drag the module from one workbook to another. Remember to Save As the workbook as XLSB or XLSM. If you leave the workbook as XLSX, your macros will be removed.

How to Multiply in Excel. This video covers eight examples: Multiply Symbol is * not X. Multiply Column by Number. Multiply by Percent. Multiply two Columns and Copy Down. Multiply by Same One Cell Reference. Multiply 3 Cells. Multiply Many Cells. Two Columns and Sum. Table of Contents (0:00) Intro (0:08) Multiply Symbol is * not X. (0:12) Multiply Column by Number. (0:24) Multiply by Percent. (0:32) Multiply two Columns and Copy Down. (0:42) Multiply by Same One Cell Reference. (0:57) Multiply 3 Cells. (1:06) Multiply Many Cells. (1:17) Two Columns and Sum.

Microsoft Excel Tutorial: How to get the sum at the top of Excel? This short video shows two methods: Add the sum at the bottom and then Cut using Ctrl+X and paste at the top. Or, start at the top, click AutoSum, and then select the range of numbers with the mouse. How To Get Sum At Top Of Excel How To Sum At The Top In Excel Table of Contents (0:00) Problem Statement: Sum at Top of Excel? (0:10) Method 1: Put total at bottom, cut, paste to top (0:20) Select cell at top, AutoSum, Use Mouse

How to add a watermark in Excel? Table of Contents (0:00) Start with a watermark image with white space above. (0:39) Adding image to Excel header. (1:25) Adjust Transparency. (2:10) Using a picture as a Watermark. (2:40) Creating a Confidential Stamp to Use in Watermark. (4:29) Bending text in WordArt.

Using Google Search autocomplete, today's question... Is Excel Infinite? Does excel go on forever? What's the last row in Excel? What's the last column in Excel?

October 17 is Spreadsheet Day - marking the anniversary of the release of VisiCalc on October 17, 1979. In this short video, an actor does an amazing job of playing Sheriff Buford T. Justice, the role made famous by Jackie Gleason in the Smokey and the Bandit movies. Have a happy spreadsheet day!