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?
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
A while back Adam shared how you can share a personal bookmark with others. There is now a better way to share personal bookmarks in Power BI if your report is in a workspace. Learn how!
Share Power BI reports and dashboards with coworkers and others
https://learn.microsoft.com/power-bi/collaborate-share/service-share-dashboards
Alternative to sharing a Power BI Personal Bookmark
https://www.youtube.com/watch?v=-c1-VQ6RsrA
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— rel=”nofollow”>http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #Bookmarks #GuyInACube
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”
There are different reasons why your Agg isn’t being hit in Power BI. In this video, Patrick looks at a specific reason based on the DAX functions you are using. Gotta watch out!
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools Continue reading “Why isn’t my Agg being hit in Power BI???”
Using notebooks in Azure Synapse Analytics? Do you find yourself wanting to have a dynamic value for use with your pipelines? Patrick shows you how you can accomplish this!
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – <a href=”https://guyinacube.com/tools/” Continue reading “Parameterize your Notebooks in Azure Synapse”
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