Lane Data Strategies | Poke

Lane Data Strategies @UC-UIumMGXgQA5NezehccVKQ@youtube.com

13 subscribers - no pronouns :c

Welcome to Lane Data Strategies – your go-to hub for unlocki

Videos Playlists

Recently Uploaded Popular Oldest

Pull data from a range based on the position of an item within a separate range | INDEX() MATCH()

Find the relative position of an item within a specified range | MATCH() Function

Function that Returns TRUE if any logical expression listed is TRUE & FALSE if ALL are FALSE | OR()

IF() a Logical Expression is TRUE or FALSE Assign a Value | IF() & Stacked IF() Statements

Insert a Range that Automatically Updates Across Multiple Tabs | INDEX() in Google Sheets and Excel

Quickly Flip the Format of your Dataset | TRANSPOSE() in Google Sheets and Excel

Get a Sum or Average of a set of numbers based on either a single [IF] or multiple [IFS] criteria

Combine Multiple Cells Into a Single String | CONCATENATE() vs TEXTJOIN()

FIND or FILTER multiple values - REGEXMATCH() with the Regular Expression for OR

Round Values By a Numerical Multiple - MROUND() Creates Polished, Whole Numbers

Convert Duration Cells to Usable Numerical Values - Value() Makes Time Functional

Remove Duplicates in Google Sheets - UNIQUE() Manages Large Datasets

Optimize your use of SUBTOTAL() - SUM() a Changing Filtered Range

Split form data with SPLIT() - Excel's Text To Columns in Google Sheets

Get a Random Sample Set using Google Sheet's RANDBETWEEN(), RANK.EQ(), & COUNTIF() - Random Order

Rank Your Data Easily With Rank.Eq - Rank Values & Break Ties in Google Sheets

How to Count a Cell's Occurrence in a Column - Google Sheet's COUNTIF()

Copy Dynamic Data onto Different Sheets in Google Sheets - IMPORTRANGE() Alternative to Copy Paste

Analyst's Toolkit Series | The Power of COUNTIF()

Analyst's Toolkit Series | The Ease of RANK.EQ

Analyst's Toolkit Series | Find the Random with RANDBETWEEN(), RANK.EQ(), & COUNTIF()

Analyst's Toolkit Series | Supercharge your productivity with SPLIT()

Analyst's Toolkit Series | Transforming Your SUM with SUBTOTAL(109)