Excel random sample?
Excel random sample without replacement?
Excel how to random sample?
Excel random selection from list?
Excel random selection from list no duplicates?
Excel random row selection?
Excel random cell selection?
Excel random list selection?
Is there a random selection function in excel?
Can Excel randomly select from a list?
Can Excel randomly select rows?
Using Excel random selection?
Can Excel make random selections?
Sort a list into random sequence.
Can Excel Randomly Sort Data?
Excel Create Random Order?
Excel Random Sort?
Can Excel Randomly Sort Data?
Excel How To Random Sort?
Excel Random Order?
Excel Random Order List?
Excel Random Row Order?
Excel Create Random Order?
Excel randomly choose Yes or No.
Use CHOOSE and RANDBETWEEN for a roughly 50/50 split.
Or use IF and RAND to generate an approximate percentage of one or the other.
How can you randomly choose between male or female in Excel?
Randomly choose gender in Excel?
Excel randomly choose between two items?
In this video, several of my friends and I propose ways to cut a 75-minute Excel process down to under 15 seconds. As expected Diarmuid Early posts the fastest time with an under-10-second solution. But Diarmuid warns about a possible problem in the data, which makes a method proposed by Peter_SSs and Anup Agarwall the fastest and safest method.
The formula methods from others:
https://www.mrexcel.com/board/threads/excel-insert-blank-row-after-every-two-data-rows-shorts.1217116/
https://www.mrexcel.com/board/threads/insertblankat.1217374/
Table of Contents
(0:00) Hurricane Ian delay
(0:34) 2-minute solution for OP
(1:11) 53-Second solution
(1:30) Too Slow
(2:10) Fastest Excellers
(2:30) Anup Agarwal
(3:07) Diarmuid Early I
(4:06) Diarmuid Early II
(4:35) Imagining OP data
(4:52) Other solutions
(5:09) Formula dependencies between Continue reading “Excel 75 Minute Process To 13 Seconds – 2523”
After sorting by number of characters in a cell, we get a variant from Thinks Too Much (b): Can you sort, factoring in the width of the letters in the font that is being used?
Table of Contents
(0:00) Welcome Back
(0:12) Question
(0:40) VBA code to measure width
(1:44) Differing fonts & sizes
(2:15) Nancy Faust
Here is my VBA solution:
Sub SortAscCustomerWidth()
FinalRow = Range(“E1048576”).End(xlUp).Row
OrigWidth = Columns(5).ColumnWidth
HelperColumn = Range(“XFD1”).End(xlToLeft).Column + 1
Cells(1, HelperColumn).Value = “Helper”
‘ Loop
For Each cell Continue reading “Excel Sort A Column By Font Width ? 2522”
How do you sort a column in Microsoft Excel by the number of characters? This video was inspired by a question originally posted at Quora: https://www.quora.com/How-do-you-sort-a-column-in-Microsoft-Excel-by-the-number-of-characters/answer/Bill-Jelen
Table of Contents
(0:00) Welcome
(0:13) SORTBY
(0:49) Problems!
(1:06) VSTACK
(1:30) Copy & Paste Values
(1:47) Easy Helper Column
Here is a great trick I learned a decade ago from Mack Wilk.
I have a long list of topics in Excel.
I want to convert it to a collapsible outline view.
There is one secret hidden setting that you need to change first.
Then, it is all very easy.
Join the MrExcel community: https://www.mrexcel.com/community/
Table of Contents
(0:00) Need for outline in Excel
(0:28) Secret hidden setting
(0:48) Select detail rows for group 1
(1:05) Group & Outline buttons
(1:25) Select rows with Shift Spacebar
(1:45) Using the Group buttons
(2:09) Third Thursday Webinar
This video answers these common questions:
what does grouping cells in excel do?
what does grouping Continue reading “Excel Easy Collapsible Outline View – 2521”
Download Excel file: https://excelisfun.net/files/08-M365ExcelClass.xlsx
Download pdf notes: https://excelisfun.net/files/08-M365ExcelClass.pdf
Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
Topics in video:
1. (00:00) Introduction
2. (01:35) XLOOKUP function
3. (02:04) Exact Match Lookup
4. (04:00) Data Validation List
5. (07:19) Lookup a Record
6. (08:50) Lookup a Column
7. (10:37) Exact Match or Next Smaller Lookup (Approximate Match Lookup)
8. (14:24) Vertical or Horizontal Lookup?
9. (15:40) Lower Limit for Exact Match or Next Smaller Lookup
10. (16:48) Exact Match or Next Bigger Lookup
11. (21:15) Wild Card Lookup
12. (23:10) Lookup First Item
13. (24:57) Lookup Last Item
14. (26:11) Lookup Continue reading “All Important Excel Lookup Formulas: Excel Worksheet, Power Query & DAX – 28 Examples! – 365 MECS 08”
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!
Today – October 17 is SPREADSHEET DAY! This marks the anniversary of the October 17, 1989 release of the first spreadsheet – VisiCalc. For any #StarTrek fans out there, we have a cool spreadsheet day message from Lt. Commander Shelby. I should have asked if #Excel was still the dominant spreadsheet in the future.
October 17, 2022 is spreadsheet day. For all of you who can pivot data as quickly as Nate “Big Easy” Lofton can spin a ball on his finger, Happy Spreadsheet Day! #Globetrotters #HarlemGlobetrotters #HappySpreadsheetDay