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” →

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” →

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” →

Stevenson asks: Why won’t this SUMIFS work inside of a LET function in Excel?
It turns out that he is trying to do a calculation in the first argument of the SUMIFS.
This is against the rules.
If you would have tried it without the LET, Excel would have given you the mysterious error of “There’s a Problem With This Formula”.
When you try to do it inside of LET, the formula parser is not smart enough to refuse the formula, but you end up with a bunch of #VALUE! errors in Excel.
The same limitation applies to SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS, SUMIF, AVERAGEIF, Continue reading “Excel Why Wont This SUMIFS Work Inside Of Let 2518” →