Dynamically Combine tables Excel

Поделиться
HTML-код
  • Опубликовано: 16 июл 2024
  • Dynamically combine tables excel - This video shows how to dynamically combine tables in excel via the user's choice of a checkbox
    00:00 Introduction
    00:36 Problem description
    02:17 Building blocks -Filter Function - Tables to include
    03:08 Indirect function
    04:35 Reduce Function - How it works
    07:38 Building the Complete solution
    13:40 Final Fixes
    14:10 Concluding thoughts
    Link to workbook:
    docs.google.com/spreadsheets/...

Комментарии • 42