PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900

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

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

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

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

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

Create Random Dates with Excel Functions. Excel Magic Trick 1894

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

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

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

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

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

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

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

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

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

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

The Beauty Of Power Query! One Quick Example : )

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

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

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

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

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

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

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

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

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

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

Dynamic PivotTable To Count SalesRep Monthly Sales & Visualize Trend. Excel Magic Trick 1869

Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868

2024 Christmas Tree with Excel Formula

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

Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865

Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864

GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863

1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862

UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861

Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860

GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855

Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858

PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859

Generate Random Data Sets with Dates & Sales Numbers: RANDARRAY Function. Excel Magic Trick 1857

Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856

Worksheet Formulas to Group Transactions with No Transaction Number. Magic Trick 1854

Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853

Append Tables in Excel. Excel Magic Trick 1852

Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851

Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850

Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849

Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848

Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847

ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846

Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845

2 Different Functions in GROUPBY & PIVOTBY Functions. Excel Magic Trick 1844 Part 2

GROUPBY Excel Worksheet Function. Single Cell Reports Made Easy! 11 Examples. EMT 1844

FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843

FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842

FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841

Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840

Excel Formula: Extract City Name from Description. Excel Magic Trick 1839

Lookup Multiplying For Commission Calculation: FILTER, XLOOKUP, LAMBDA & BYROW. EMT 1838.

Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836

Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function?

FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837

Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835

Create Excel Master Table from Sub-Tables Using Power Query. Excel Magic Trick 1834

XLOOKUP or VLOOKUP Based on Sheet Tabe Name!?! Excel Magic Trick 1833

Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832

Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831

LOOKUP Beats XLOOKUP For Horizontal / Vertical Lookup. Excel Magic Trick 1830

LOOKUP Beats XLOOKUP For Single Cell Revenue Calculation. SUMPRODUCT Too! EMT 1829

Federal Income Tax Calculation: LOOKUP Function Beats VLOOKUP & XLOOKUP! EMT 1828 Part 3

LOOKUP Function Can Do VLOOKUP or HLOOKUP, But Be Careful! EMT 1828 Part 2

LOOKUP Beats XLOOKUP at Approximate Match for Discounts, Taxes, Commissions. EMT 1828

3 Power Query Formulas: Hours Worked for Day & Night Shift from Time Values. Excel Magic Trick 1827

Formula to Calculate Hours Worked in Excel & DAX: Day or Night Shift! Excel Magic Trick 1826

Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825

Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824

Excel Formula To Randomly Lookup Pictures or Any Item. Excel Magic Trick 1823

Lookup Picture with Excel Formula – XLOOKUP or FILTER - Excel Magic Trick 1822

Conditional Format Row When Employee Is Listed More Than 1 Time For Date. Excel Magic Trick 1821.

Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820

Word Replace Feature for Special Characters: Replace All Hard Returns with 2 Hard Returns. #Short

Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819

Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818

Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_

Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817

excelisfun @ YouTube for 15 Years! Birthday Party!

Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts

Save Time in Excel: Copy Only Excel Format with Format Painter. Excel Magic Trick 1815 #Shorts

Remove All Excel Format to Help Fix Reports and Data Errors. Excel Magic Trick 1814 #Shorts

Average Difference Between Ship Date Column & Order Date Column - Excel Magic Trick 1813 #Shorts

Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shorts

Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811

Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810

Excel Sparkling Christmas Tree with Changeable Ornaments with LAMBDA function! EMT 1809

Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808

Conditional Formatting for Consecutive Numbers with Logical Formula. Excel Magic Trick 1806

UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805

Spilled 2-Way Lookup Commission Report using LAMBDA and BYROW Functions. EMT 1803

XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804

Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802

FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801

Show all Formulas in Single Column – Awesome Model Documentation Trick - Excel Magic Trick 1800

FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799

Create Sequence of Time Values in Excel for Stock Market Price Data – Excel Magic Trick 1798

Excel Formula to make First a 1, Second a 2, Third a 3, and so on. 6 Formula Examples. EMT 1797

Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796

Excel Text To Columns or Split to Rows: Worksheet Formula or Power Query? Excel Magic Trick 1795

excelisfun’s new book The Only App That Matters Book is Released!!! Microsoft 365 Excel = The Best!

Excel Formula to Lookup Cell Address Of Max Value: 12 Amazing Examples. Excel Magic Trick 1794

Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793

Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792

XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791

Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790

TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789

DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788

Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787

VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786

TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785

WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784

Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783

14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782

HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781

HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780

3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779

Power Query: Extract Records For Invoices 1 to 30 Days Past Due - EMT 1778

COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777

Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method - EMT 1776

Sum Top 3 Values When There Is Missing Data – 3 Unbelievable Solutions (LAMBDA too) EMT 1775

Turn Off GETPIVOTDATA Function - EMT 1774

Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773

Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772

FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771

Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770

SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769

Excel Flashing Christmas Tree 2021- Happy Holidays Old School Formula Method. EMT 1768

Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767

Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766

Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765

Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764

Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS & LAMBDA. Excel Magic Trick 1763

Why Excel NPV and XNPV Function Give Different Answers for Cash Flow Analysis. EMT 1762

Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761

INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2.

VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760

Excel Hack Video: Power Query to fix files in Windows Explorer? Excel Magic Trick 1759

VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758

Power Query From Sheet option Import Tables, Defined Names or Dynamic Arrays. Fast Keyboard EMT 1757

Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756

Import OneDrive File or Folder using Power Query. EMT 1755

Excel Conditional Formatting for a Chess Board or Checkerboard. Excel Magic Trick 1754

Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753

Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752

Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751

Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750

7 LAMBDA Helper Functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY. EMT 1749

Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748

Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747

IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746

Excel Magic Trick 1745 Part 2: Create & Spill Random Normally Distributed Values

11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745

Average Excluding Min and MAX Values. TRIMMEAN function. 6 Formula Examples. EMT 1744

OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743

Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742

Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741

Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740

SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739

Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738.

Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737.

Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736.

Organizational Data Types in Excel M365 & Power BI. Excel Magic Trick 1735

Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734.

Create PivotTable in Excel Online. Excel Magic Trick 1733.

Excel AI with Analyze Data Tool. PivotTable, Pivot Chart & X-Y Scatter Charts Excel Magic Trick 1732

Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731

PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730

4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729.

[Private video]

Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.

Moving Annual Total with DAX Measure. Excel Magic Trick 1726.

Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725

Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724

Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723

Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722

Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2

Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721

PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720

Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719

INDEX & SEQUENCE functions to Spill a Constant Value Down Column. Excel Magic Trick 1718

Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717

Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716

Instant Help with Excel Function: Hot Link, Keyboard or Screen Tip? Excel Magic Trick #1715

Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.

Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713

INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712.

Excel Magic Flashing Christmas Tree. Plus, BIG LET Surprise!!! Excel Magic Trick 1711

Lookup Last Payment Date. 5 Methods for any version of Excel! Excel Magic Trick #1710

Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick #1709

Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708.

12 Array Formula Tricks That Will Blow Your Mind! for Single Cell Spilled Sales Report. EMT 1707

LAMBDA Excel Function. LET & LAMBDA together to make Single Cell Reports. Excel Magic Trick 1706

MOD function & Number.Mod Functions. Why They Give Different Answers. Excel Magic Trick 1705.

Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704.

Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703.

Basics of Excel Spilled Array Formulas to create Monthly Sales Report. Excel Magic Trick 1702.

Basics of SUMIFS & PivotTables for Monthly Sales Report. Excel Magic Trick 1701.

Biggest Sale for Each Product: PivotTable, Formulas or Power Query? Excel Magic Trick 1700.

Dynamic Spilled Array Formulas for Future Value Cash Flow SIP Step Up. Excel Magic Trick 1699.

How to Rank in Power Query. EMT 1698 by excelisfun.

OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697.

Excel FILTER based on list, not individual values? Easy! Excel Magic Trick 1696.

Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695.

XLOOKUP function to do Double LEFT Lookup! Excel Magic Trick 1694.

FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693.

Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691.

Create Excel Database and Data Entry Form. Excel Magic Trick 1690.

Power Query to List Students Last Access Date & Time for Class Web Site. Excel Magic Trick 1689.

List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688.

List Student Last Access Date & Time for Class Web Site with Formulas. Excel Magic Trick 1687.

Dynamic Excel Amortization Table. Microsoft 365 Spilled Array Magic! Excel Magic Trick 1686.

FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685.

SPLIT, JOIN and ARRAYFORMULA Functions in Google Sheets to Split Text & Add Numbers. GS 1. EMT 1684.

Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683.

Append Two Number Columns and Sort. Excel Magic Trick 1682.

LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681.

Excel Conditional Formatting Weekend & Holiday Date for Row in Table. Excel Magic Trick 1680.

Excel Table Column Formulas and Spilled Arrays? Excel Magic Trick 1679

Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678.

Replace & Text To Columns to Convert Text Dates to Real Dates. Excel Magic Trick 1677

Convert SAP Dates to Real Dates in Excel. Excel Magic Trick 1676

Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675.

Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674

LET Function for Dynamic Reporting in Single Cell. Excel Magic Trick 1673

Lookup 2nd Smallest Number. 2nd Biggest too. UNIQUE or FREQUENCY function? Excel Magic Trick 1672

SORTBY, UNIQUE, INDEX and SUMIFS Functions: Dynamic Spilled Array Reports. Excel Magic Trick 1671

Remove Numbers from Text. Flash Fill, Power Query, Formula or LET Function? Excel Magic Trick 1670

Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.

Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667

Show File Extensions (File Types). EMT 1666

Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665.

Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664

Extract Data From Cell, Display Horizontally with Excel Formula. 5 Examples. Excel Magic Trick 1663

Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661

Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660.

Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662

Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659

Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658.

PivotTables Are Easy: 6 Criteria Cross Tabulated Counting Report. Excel Magic Trick 1657.

COUNTIFS 6 Criteria Counting Cross Tab Report. Change Cell Reference Every 3 Columns Too! EMT 1656

Excel Music Video: UNSTOPPABLE Office 365 Excel. Old School Formulas v. New School Formulas EMT 1655

INDEX Function & Spilled Arrays to Extract Last Rows in Table. Fully Dynamic!! EMT 1654

Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653

Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652

Dynamic Yearly Sales Report with Excel’s Dynamic Spilled Array Formulas. Excel Magic Trick 1651

Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650.

Create a Dynamic Lookup Table using INDEX & LOOKUP Functions. Excel Magic Trick 1649

Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648

Sum, Count & Average using an OR Logical Test. Many Cool Formulas. Excel Magic Trick 1647

Append Multiple Columns with Excel Dynamic Spilled Array Formula. Excel Magic Trick 1646.

OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645

Stack 2 Columns (Append). INDEX Function or Power Query? Excel Magic Trick 1644.

Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643

Excel FIXED Function Easier than TEXT Function! (DOLLAR Function too). Excel Magic Trick 1635

excelisfun YouTube Birthday Party: 12 Years @ YouTube. Feb 15, 2008 – Feb 15, 2020.

Flash Fill, Array Formula or Power Query? To Insert Dash Between Text & Number. EMT 1641

REPLACE Function to Insert a Dash Into Text. Flash Fill Too. Excel Magic Trick 1639

Which Lookup Formula is Fastest? Excel Magic Trick 1631 Part 02

Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634

Power Query to Insert Dashes into Text. Flash Fill too! Excel Magic Trick 1638

TEXTJOIN & MID? LEFT, 2 MID, RIGHT? Excel Formulas to Insert Dashes into Text Excel Magic Trick 1637

Excel Formula for Discounted Sales: Standard Formula or Spilled Arrays? Excel Magic Trick 1636

Repeat Number Down Column with Excel Formula & Conditional Formatting - Excel Magic Trick 1633

Dynamic Inventory Running Total Excel SUMIFS Formula Based on Transaction Records (EMT 1632)

Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631.

Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629.

Spilled Array Christmas Tree in Excel. Conditional Formatting Christmas Tree. Excel Magic Trick 1628

Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621

VLOOKUP & LEFT Functions #N/A Error. And Lookup Code is in List?!? Excel Magic Trick 1627

Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626)

Remove Spaces From Column Names in All Tables Automatically in Power Query - EMT 1625

Double The Records When I Refresh? Power Query Excel.CurrentWorkbook Recursion - EMT 1624

Repeat Columns in my Power Query Append?? Too Many Columns? Extra Columns? EMT 1623

Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622)

Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620

How To Import Text File into Excel (4 Examples, including Tab & CSV Files) – Excel Magic Trick 1619

INDEX & MATCH Excel Lookup Functions - All You Need To Know in 10 Minutes (EMT 1618)

Split Text By Capital Letters in Excel using Power Query EMT 1617

Split Text By Capital Letters in Excel using Power Query EMT 1617

Bring Excel Sheet Variable Into a DAX Measure (Measure Input From Excel Sheet) EMT 1616

Bring Excel Sheet Variable Into Power Query (Query Input from Excel Sheet) - EMT 1615

TEXTJOIN & TEXT Functions working on Multiple Rows or Columns (DOLLAR Function too) EMT 1614

Excel Formula: Count Matches in Both Lists. Conditional Formatting to Format Matches. EMT 1613

Excel Formula for Text Number Label with Lead Zeroes: 010-030, 030-050, 050-070 - EMT 1612

XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup Values! –- Excel Magic Trick 1611

Extract Top 5 Values with Names with Dynamic Array Formulas & Conditional Formatting – EMT 1610

Excel Formula to Sum All Digits: Old School Dynamic Array Formula? Excel Magic Trick 1609