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
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”
Today, October 17, 2022 is International Spreadsheet Day. Microsoft has asked a lot of creators to post their favorite Excel tips. Here is mine: Double-click the Fill Handle to copy a formula to the bottom of the data.
It’s been 4 months since I have posted a skatepark BMX and Skateboard video. This was rad fun on Sunday, Oct. 16, 2022 at Delridge Skatepark and Jefferson Skatepark with Isaac “Iceman” Girvin and Mike “excelisfun” ‘Magic” Girvin.
This is the best way to get fuel to make Excel videos and write Excel books during the week : )
The Boneless Ones Skate Punk Band Song Back To The Grind pumps the action and creates rad!
Washington BMX / Skate Adventure 17.
How to split delimited into rows.
I tried using Power Query.
With Power Query I can do it only for 1 column.
If I select more than 1 column, the Split Column is disabled in the Power Query Editor.
Is there any other solution for splitting delimited into rows for more than one column?
This video offers three solutions.
Solution 1 is a formula such as =TEXTJOIN(“|”,,TEXTSPLIT(C2,”,”)&”-“&TEXTSPLIT(B2,”,”)) and then Power Query.
The 2nd solution is M code written by Suat Ozgur. Get that code from MrExcel:
https://www.mrexcel.com/board/threads/power-query-split-to-rows-for-2-similar-columns-2520.1219302/
The 3rd solution is two intermediate queries in Power Query and then a merge query.
Table of Contents
(0:00) How Continue reading “Power Query Split To Rows For 2 Similar Columns – 2520”
Download Excel File: https://excelisfun.net/files/EMT1800.xlsx
Learn how to show all formulas in a column using a single formula.
Topics:
1. (00:00) Introduction
2. (00:17) Show all formulas in a column using a single formula using TOCOL, ADDRESS, ROW, COLUMN and FORMULATEXT functions
3. (03:30) Summary, Closing, Video Links
Can someone please help me???
I have an Excel file that has the cost column in cents so if something is 1.25 it is showing as 125 .
When I change it to currency the numbers change to 125.00….
Anyone knows how to fix the issue faster than one by one. I have over 5,000 items to go through!
In this short video, learn how to multiply an entire column by 0.01 to quickly convert 125 cents to 1 dollar and twenty five cents.
In Excel… How does one create a character+number THAT ONLY UPDATES WHEN ENTERED and DOES NOT change with F9 or reloading the spreadsheet?
I want to create sort of an inventory number that I can put on my 3D printer filament boxes to identify them quickly.
But I don’t want the inventory number to ever change after the first creation of the numbers/characters.
This video answers these questions:
Excel random not change?
Excel random keeps changing?
why does random number change in Excel?
Excel random number without changing?
how to stop Excel random number changing?
can i generate random numbers in Excel?
Excel and random number generator?
Excel rand Continue reading “Excel Enter Random Numbers That Will Not Change Again – #shorts”
Download Excel File: https://excelisfun.net/files/EMT1799.xlsx
Learn how to filter records based on a list of values using Excel worksheet formula.
Topics:
1. (00:00) Introduction
2. (00:26) Filter records based on a list of values using FILTER, XMATCH and ISNUMBER functions.
3. (02:22) VSTACK function to Filter records based on one or more lists from any were on worksheet.
4. (03:19) TOCOL function to Filter records based on one or more lists that are listed sequentially.
5. (04:09) Summary, Closing, Video Links
Excel getting the unique values going across a row.
The Remove Duplicates command in Excel always removes rows. What if you want to remove duplicates that appear in the same row? The UNIQUE function offers a By Column option.
Also in this video: Sorting sideways in Excel using the Left-to-Right Sort option.
What happens if you leave off the optional By_Col argument in UNIQUE.
Why UNIQUE returns the original range.
Table of Contents
(0:00) Sort or Unique sideways in Excel
(0:37) UNIQUE by Column
(1:48) Nested arrays not supported
(2:00) Sorting sideways in Excel
(2:38) UNIQUE of rectangular range
(3:33) Why UNIQUE returns original range
(4:15) BYCOL defaults to False
(4:35) UNIQUE Continue reading “Excel Unique Across Each Individual Row – 2519”