SUBTOTAL: A More Mature Alternative to the SUM, AVERAGE & Other Functions

SUM, AVERAGE, COUNT and their conditional equivalents are staples in Microsoft Excel and Google spreadsheets. However, there is a seldom-used alternative that allows users to incorporate those functions and a few others in one line: SUBTOTAL. Here’s how it works:

Continue reading "SUBTOTAL: A More Mature Alternative to the SUM, AVERAGE & Other Functions"

The Rare Pair: How to Use LOOKUP and HLOOKUP

There are a few lookup functions you can use in spreadsheets. HLOOKUP is one of the more familiar functions, but not many have heard about LOOKUP. It’s a rare function that’s really only useful in one particular task.

Continue reading "The Rare Pair: How to Use LOOKUP and HLOOKUP"

Index/Match Formula in Google Sheets with a Quick Example

Index/Match is a pretty popular formula combination that gives you the ability to move and manipulate data across Google spreadsheets, helping you to get the data you need faster. In order to understand how this works, let’s break things down.

Continue reading "Index/Match Formula in Google Sheets with a Quick Example"
Regular Expression Syntax to help you Manipulate Your Data - TeXXic by Transitionyte.com

How Regular Expressions Can Help You Manipulate Your Data

When it comes to getting the most from a spreadsheet, being agile with regular expressions, RegEx, as it relates to data analysis, is a powerful skill to have. As a former retail marketing analyst, I used Excel extensively, and I grew to love and respect it even more than before. It’s a powerful tool that’s …

Continue reading "How Regular Expressions Can Help You Manipulate Your Data"

How Marijuana Can Improve Sex

Marijuana Can Even Help Some Women Overcome A Psychological Condition That Leads To Painful Intercourse   As more regions adopt cannabis, there have been no ends of testimonials about how the herb does wonders for everything, including sex. This is important because more than 40 percent of women and approximately 30 percent of men experience …

Continue reading "How Marijuana Can Improve Sex"
How Bacteriophages Can Save Us From Antibiotic Resistance - Bacteriophages.com

How Bacteriophages Can Save Us From Antibiotic Resistance

Phage Therapy Has Been Around for A Century, But It Was Pushed Aside for the Very Treatment That’s Losing Its Efficacy. Photo by Michael Schiffer on Unsplash What do Streptococcus pyogenes, Neisseria gonorrhoeae, and Acinetobacter baumannii have in common? These are three of 10 bacteria that doctors are worried about, because they are becoming more resistant …

Continue reading "How Bacteriophages Can Save Us From Antibiotic Resistance"