Excel Mystery: Someone reports they have 7 cells with data. One of them has a mystery line at the bottom of the cell. It is not a border. What else could it be?
Category: Excel
MrExcel Favorite Excel Spreadsheet – Arranging Player Piano Rolls
A look back to the early days of Tickling Keys, Inc. – when our main product was rock and roll player piano rolls. This is my favorite spreadsheet. What is yours? #ExcelAtEverything
Thanks to video footage from David Shivers at the Salem (Ohio) Historical Society.
Excel Random Date or Random Date and Time – 2524
How to generate random dates in Excel.
How to generate random date and time in Excel.
Table of Contents
(0:00) Welcome
(0:34) Random Date in Excel
(2:38) Random Time in Excel
(3:01) RandomTime During the Workday in Excel
(3:58) Random Time to nearest quarter hour
(4:45) Random Date /Time in Excel
(5:36) Random Weekday in 2025 in Excel
(6:44) Random Weekday No Holidays in Excel
(7:45) Randomly Choose a Monday or Thursday in Excel
(9:19) Randomly Choose particular weekdays in Excel
(10:35) Wrap-Up
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 Randomly Choose Yes Or No #Shorts
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.
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”
All Important Excel Lookup Formulas: Excel Worksheet, Power Query & DAX – 28 Examples! – 365 MECS 08
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”