This is a weird thing I just discovered, so I thought I'd post it just in case it helps someone else. If you use Microsoft Excel, it's possible to filter rows by colour. But it turns out there's a limitation;

Post number 11 of “The Practical Google Sheets Guide” These blog posts are part of research I’m doing for a potential new book, hopefully allowing me to further my love for spreadsheets. Theses posts are

Post number 10 of “The Practical Google Sheets Guide” These blog posts are part of research I’m doing for a potential new book, hopefully allowing me to further my love for spreadsheets. Theses posts are

Determining the proper URL to use in posts is usually easy, until it isn't. Here's one way I handled it when it wasn't. Cover image is an edited screen capture I made while using InLeo to "draw"

WEN LAND? Wen Land, the players of Splinterlands cried for an eternity. With the advent of the White Paper; a whole bunch of people started to realise that they needed to obtain a lot more cards. Others,

Tonight I discovered something sneaky about SUM() in Excel. It may be this way in programs compatible with Excel, too.

How can 5 numbers less than 100 lead to a sample variance over 1000? Is Excel 2003's VAR() bugged? XLSref investigates.

Did Excel 2003's DB() function have a bug? Who knows? That's why I investigated this for XLSRef (powered by LeoThreads).

Did Excel 2003's DB() function have a bug? Who knows? That's why I investigated this for XLSRef (powered by LeoThreads). Images are edited screen captures from either Excel 2003 or LeoThreads. Edits made

Checking out some variables for how many chests and rshares people should expect

Unless we're like @taskmaster4450, @edicted, or @bitcoinflood, we only have the 1st 140 characters to get a reader's attention. Let's make the first 140 charactercount! See Footnotes for image details:

Below is a table with links to the 3 parts of the post "The Spreadsheet Behind thD.Buzz Character Count Post Form for Buzzes (and Tweets)": PostDateTopics Covered 2022-02-23 @ 5:20pmBehind the

The previous post covered functions and formulas. Normally they are used in the grid that's on screen. However, functions an formulas can be used in a number of behinf the scenes tools of spreadsheet programs

The previous post briefly covered simple data values, cosmetic features, and merged cells for data entry; It also went into somedetail on named ranges. So Part 2 for this 3-part post is about the functions

The previous post in this series introduced the D.Buzz Character Count Post Form. It explained how the spreadsheet-based form works from the point of view of someone using the form. So this 3-part post

D.Buzz is Hive's version* of Twitter. Posts on D.Buzz are called buzzes. Both apps impose a character limit on posts; D.Buzz allows 280 characters in the body. At the moment, I'm locked out of D.Buzz,

Bitcoin's nickname is "The King of Cryptocurrency." Pelé is the alias for Edson Arantes do Nascimento. How are named ranges like nicknames? Just as people and things can be referred to by other

A few years ago there was a solar eclipse. Those are rare events, so when the occur people want to see it. However, it's one of those things we're told never to look at directly. We're told to use pinhole

Hot off the press at LeoFinance: Spreadsheets for Blogging: How Are Cell References Like Chess Pieces? #dbuzz #excel #spreadsheets #leofinance #hive #pob #cent #crypto #archon #pal #bht #neoxian

In Chess, each piece has its own rules for moving on the board. Pawns can move just one square forward at a time. Rooks can move any number of squares in either vertically or horizontally. Bishops can