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.
Category: Power Pivot
Excel Random Sample From A List – #shorts
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?
Excel Create Random Order #shorts
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 Random Male Or Female #shorts
How can you randomly choose between male or female in Excel?
Randomly choose gender in Excel?
Excel randomly choose between two items?
Excel 75 Minute Process To 13 Seconds – 2523
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”
Excel Sort A Column By Font Width ? 2522
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”
Excel Sort A Column By Number Of Characters – 2521
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
Excel Easy Collapsible Outline View – 2521
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”
Happy Spreadsheet Day From Sheriff Buford T Justice #shorts
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!
Happy Spreadsheet Day From Star Trek Lt Commander Shelby aka Elizabeth Dennehy #shorts
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.
Harlem Globetrotter Nate Big Easy Lofton – Happy Spreadsheet Day – #shorts
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
Reggae Pioneer Willie Dickson Plays for Spreadsheet Day
Jamaican Reggae Legend Willie Dickson of Willie Dickson and the Playboys wishes everyone a happy spreadsheet day and then dazzles us with drum rendition of the Rasta Beat.
Background vocals by Dickson’s Russea’s High School schoolmate Llewelyn Grant.
Special performance for spreadsheet day by a legendary drummer and one of the godfathers of Reggae and a legendary drummer.
Funny story: When I first heard of Willie Dickson, I confused him with Chicago blues legend Willie Dixon who has passed away. Our Willie Dickson tells of meeting Willie Dixon on the road in Montreal one time when they were Continue reading “Reggae Pioneer Willie Dickson Plays for Spreadsheet Day”