Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866

GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870

BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871

Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872

Add Secondary Series of Numbers To Excel Chart & Add Second X-Axis Labels to Chart: EMT 1873

FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874

No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875

Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876

PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877

Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70

Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71

Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878

PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879

GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks?

Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882

GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883

The Beauty Of Power Query! One Quick Example : )

File Explorer Skills To Be Good In Excel? 100% Yes! File Extensions & F2 Trick! EMT 1885

Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886

INDEX & MATCH: Simultaneous 2-Way Lookups into Accounting Trial Balance & Add Results. EMT 1888

Multiple 2-Way Lookup Intersecting Values Conditional Formatting XMATCH Logical Formula. EMT 1889

Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890

COUNTIFS, SEQUENCE, MOD Functions to Calculate Dice Probabilities in Excel. Excel Magic Trick 1891

Excel Formula to UnPivot!? with Magic From the Functions: TOCOL, IFS, CHOOSEROWS & More! EMT 1887

Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887

Excel REPLACE function Beat FlashFill to Insert Dash into Description. Excel Magic Trick 1892

XLOOKUP, LEFT, TEXTBEFORE, & LOOKUP Functions & Math Tricks to Calculate Discounted Sales! EMT 1893

Create Random Dates with Excel Functions. Excel Magic Trick 1894

Convert Proper Date to ISO YYYYMMDD Date. Excel Magic Trick 1895.

Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896

Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897

Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898

Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899