1. Summarize & Transpose Data & Remove Duplicates Ignoring Case (Dynamic Array Formula) in Excel

    Summarize & Transpose Data & Remove Duplicates Ignoring Case (Dynamic Array Formula) in Excel

  2. Basic to Advanced Lookup Formula in Excel

    Basic to Advanced Lookup Formula in Excel

    32
  3. Lookup & Return Multiple Values in Single Cell in Excel (NO VBA | Easy Dynamic Array Formula)

    Lookup & Return Multiple Values in Single Cell in Excel (NO VBA | Easy Dynamic Array Formula)

    1
  4. Dynamic Aggregation using LET Function in Microsoft Excel (Dynamic Array Formula)

    Dynamic Aggregation using LET Function in Microsoft Excel (Dynamic Array Formula)

    3
  5. Excel Array Formula: Count Rows with OR Condition - Excel MMULT Function (Part 2/3)

    Excel Array Formula: Count Rows with OR Condition - Excel MMULT Function (Part 2/3)

    4
    0
    83
  6. Excel HACK: Change HORIZONTAL Data to VERTICAL (NO Transpose Function needed)

    Excel HACK: Change HORIZONTAL Data to VERTICAL (NO Transpose Function needed)

    3
    0
    125
  7. 3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)

    3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)

    3
    0
    125
  8. Excel FILTER Function TRICK for Non Adjacent Columns

    Excel FILTER Function TRICK for Non Adjacent Columns

    4
    0
    80
  9. Quick Excel Trick to Unstack Data from one Column to Multiple Columns

    Quick Excel Trick to Unstack Data from one Column to Multiple Columns

    3
    0
    138
  10. Left Lookup in Excel with XLOOKUP (Made Easy)

    Left Lookup in Excel with XLOOKUP (Made Easy)

    4
    0
    16
  11. From Static to Dynamic Interactive Excel Charts | Carlos Barboza

    From Static to Dynamic Interactive Excel Charts | Carlos Barboza

    6
    0
    7
  12. Create an Interactive Top N Report in Excel (includes duplicate values) with Filter Function

    Create an Interactive Top N Report in Excel (includes duplicate values) with Filter Function

    3
    0
    34
  13. Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)

    Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)

    3
    0
    20
  14. Many SEARCHABLE Drop-Down Lists in Excel (No VBA)

    Many SEARCHABLE Drop-Down Lists in Excel (No VBA)

    4
    0
    46
  15. Are YOU Ready for the NEW Excel? (New Calc. Engine & Dynamic Arrays)

    Are YOU Ready for the NEW Excel? (New Calc. Engine & Dynamic Arrays)

    3
    0
    19
  16. Easily Import Data from Web to Excel (2 Practical Examples)

    Easily Import Data from Web to Excel (2 Practical Examples)

    3
    0
    29
  17. How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

    How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

    3
    0
    40
  18. Excel Dynamic Arrays (How they will change EVERYTHING!)

    Excel Dynamic Arrays (How they will change EVERYTHING!)

    3
    0
    36
  19. When You Should Use the New Excel LET Function

    When You Should Use the New Excel LET Function

    3
    0
    99
  20. Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps

    Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps

    4
    0
    11
  21. Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)

    Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)

    3
    0
    21
  22. Excel Lookup to Return Multiple Values with FILTER Function

    Excel Lookup to Return Multiple Values with FILTER Function

    3
    0
    64
  23. LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)

    LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)

    4
    0
    40