All Videos Channels
  1. Excel Array Formula: Count Rows based on OR condition - Excel MMULT, INDIRECT Functions (Part 3/3)

    Excel Array Formula: Count Rows based on OR condition - Excel MMULT, INDIRECT Functions (Part 3/3)

    4
    0
    31
  2. Dynamic Aggregation using LET Function in Microsoft Excel (Dynamic Array Formula)

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

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

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

  5. Excel Formula Lookup Multiple Results: Return headers based on matrix values

    Excel Formula Lookup Multiple Results: Return headers based on matrix values

    3
    0
    6
  6. 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
  7. Why VLOOKUP is still relevant? How to solve #N/A, #REF etc errors in Excel

    Why VLOOKUP is still relevant? How to solve #N/A, #REF etc errors in Excel

    7
  8. 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
  9. Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT

    Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT

    3
    0
    9
  10. Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook

    Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook

    3
    0
    16
  12. TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    3
    0
    10
  13. Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)

    Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)

    3
    0
    15
  14. Basic to Advanced Lookup Formula in Excel

    Basic to Advanced Lookup Formula in Excel

    30
  15. 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
  16. Excel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3)

    Excel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3)

    4
    0
    14