Regex Subroutines (Repeat the Pattern, Not the Match) | Relative and Recursive Subroutines

Exterior Product & Tensor Product (Joining Vectors of Opposite Dimensions)

Model Analysis to Reduce Calculations and Time in Excel (Case: Friendly Numbers)

How to Use Logical Arrays as Mask Arrays to Search in Excel

🔴 How to Consolidate a Bank Statement in Excel by Month - Bimonthly - Semester

Funciones de Ajuste por Filas o Columnas con Matrices de Índices (Modelo de Descifrado)

Relationship between different units in data analysis (distance between minute hand and hour hand)

Block Repetitive Cycles with the Fx. RESIDUE (Double Reverse and Shift Encryption)

LookArounds: Look Back⬅️ and Look Forward➡️ with REGEX (Lookahead and Lookbehind at the same time...

Find values from a 🟢List that (are not) in another 🔴List

Block Calculations or Vectorization and Unit Recognition

Finding a Future Position from a Present Position in an Array

Sort an array in the middle of another array (Sort Between Limits)

Intra-Cell Digit Sum (Digital Root) and Check Digit

Identify Positions with Fractions | Ambitious REGEX Engine in Excel

Start and End in REGEX "^$" and Negation in Sets "[^]"

Distributed Sequence (Forward or Inverse) in Excel 🧇Waffle Chart🧇

Difference between Iteration Functions ✅WITH Memory and ⛔️WITHOUT Memory

Cómo Construir una Fórmula Multihilo en Excel (Paralelismo o Bisección)

Filter Fragments from a Text String (Master This Technique)

Filter Arrays and Create Arrays in the Same Logical Function

Compare Numbers and Texts with a Void ("")

Create Filters in Excel without the FILTER Function 🚫 (For Vectors)

Dynamic Ranges with Iteration Functions (Inverting Ranges with Multiple Columns and Empty Columns)

Synthetic Accumulators or Prefix Sum (Without Iteration Functions)

Promotion & Casting in Data Analysis with Excel

How to Create a Countdown Calendar in Excel (Visual Indicator)

Group by Time Intervals (Lower Multiples with Start Point)

Random Numbers Without Repeats (How to Shuffle a List of Numbers)

Cyclic sequences, with repetition, and movement in Excel

Selective Movement with Multiple Sorts in Excel

Repeat an Algorithm Using Iteration Formulas in Excel (MAP Function)

Word Boundaries (\b), Quantifiers, and Optionality (?) in Excel

How to use a FILTER to insert CARDS into Excel reports

Direction of Execution of Excel Functions and Formulas

Calculate Sequences with Areas and Reset Sequences with Remainder (Ladder Example)

How to Calculate the Cycles or Iterations of a Formula in Excel

Implicit Intersection for Traversing Arrays Indirectly in Iteration Functions

Splitting a Problem and Finding the Solution (using errors as conditionals)

Comparing Matrices by Traversing Another Matrix (Point Calculation in Golf)

How and why to run DIRECT MATRIX calculations in Excel

The REPEAT Function as a Logical Test (Activate Diagonal in Matrices)

Multiplying Columns or Rows with the IF.ND Function (To De-Pynamize Matrices)

Mezclar Dos Matrices (uno a uno) en Excel con Intercambios – Ordenamiento sensible

How to Create Groups with Consecutive Dates and Criteria in Excel

Totales acumulados por fecha con PIVOTARPOR (Microarreglos y Sub-Set de Datos)

Priorizar Asignaciones con Excel (Concepto de Memoria en Funciones de Iteración)

How to Protect Your Excel Workbook from Accidental Changes (Allow Drop-Down Lists Only)

Packaging Logic: The Key to Data Analysis (Auxiliary or Custom Functions)

Using Row and Column Dimensions as Containers for Variable Values

DIABETES CONTROL - Excel Template (Record: Insulin and Physical Activity)

Using Logical Values ​​to: Make Decisions and Perform Extractions

Logic Loops without Iteration Functions with Remainder & Character Offset

Permutación con Grupos de Captura e Iteración con Limites de Palabra (REGEX en Excel)

Iteraciones Concurrentes con Eliminación (Ejemplo: Coordenadas Cartesianas)

How to Use the END.MONTH Function to Filter in Excel (Remember This Tip)

Sensitive Sorts with Locking in Excel Arrays (REMEMBER THIS, Data Analyst)

How to Filter Multiple Date Ranges in Excel (Two Methods)

How to use the FILTER function with Scroll Bars – (Sunday Bonus 3) Dynamic Filters

Iteration Functions on Ranges – Maximum Capacity of a Cell – Including Limits in Sequences