Integrate CHOOSECOLS Function with Multiple Advanced Functions to Create Dynamic Report in Excel

preview_player
Показать описание
In this #Excel video, I demo how to Integrate CHOOSECOLS Function with Multiple Advanced Functions to Create Dynamic Report in Excel.

If you like this video, give it a thump up, share with your friends and subscribe to this channel for more content.
  1. Abiola David - Databricks and Microsoft MVP
Рекомендации по теме
Integrate CHOOSECOLS Function 0:11:30

Integrate CHOOSECOLS Function with Multiple Advanced Functions to Create Dynamic Report in Excel

Use CHOOSECOLS, XMATCH, 0:05:01

Use CHOOSECOLS, XMATCH, LARGE and SEQUENCE to dynamically to extract last three months data

CHOOSECOLS function - 0:00:44

CHOOSECOLS function - One of the new Microsoft Excel functions for 2022 #shorts

CHOOSEROWS and CHOOSECOLS 0:13:10

CHOOSEROWS and CHOOSECOLS functions in Excel - Dynamic Arrays

Excel FILTER Function 0:12:03

Excel FILTER Function TRICK for Non Adjacent Columns

Dynamic Excel Filter 0:02:26

Dynamic Excel Filter Function With Multiple Criteria

CHOOSECOL function in 0:00:55

CHOOSECOL function in Excel

How to Extract 0:00:49

How to Extract Specific Columns of Data from a Table in Excel using the CHOOSECOLS Function

How to Get 0:05:24

How to Get a UNIQUE List from Many Columns Using FLATTEN in Google Sheets

Excel Magic: Mastering 0:00:27

Excel Magic: Mastering the ChooseCol Formula Trick for Efficient Data Analysis!

CHOOSE Function in 0:04:36

CHOOSE Function in Excel: How to use the CHOOSE function in Excel In Financial Modeling For Scenario

How to Use 0:08:20

How to Use the FILTER Function in Google Sheets | Multiple Columns

Extract Data to 0:08:34

Extract Data to Separate Sheets the Right Way!

Excel - FILTER 0:04:55

Excel - FILTER function, multiple criteria and return only 1 column

Dynamic Array Models 0:04:47

Dynamic Array Models that will blow your mind

XLOOKUP or VLOOKUP 0:04:36

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

How to Filter 0:16:22

How to Filter in Excel

TEXTSPLIT function in 0:14:27

TEXTSPLIT function in excel - deep dive

Google Sheets | 0:04:45

Google Sheets | HSTACK | Function | Formula | Example | Spreadsheet | Tutorial | Append Range

FILTER and Return 0:04:03

FILTER and Return Specific Columns - Three Examples

How to use 0:00:34

How to use the VSTACK() function in your spreadsheet | Zoho Sheet

Use TOROW and 0:02:22

Use TOROW and TOCOL to combine data into a single row or column in Sheets and Excel

Quickly Combine Tables 0:00:51

Quickly Combine Tables with VSTACK - Excel #Shorts

How to Use 0:01:00

How to Use Python in Excel #shorts

Комментарии
Автор

Excellent solution my friend. Absolutely amazing. Thank you David!!!

IvanCortinas_ES
Автор

Amazing as always, you are a master, love your channel very much. It's fun to have such geniuses in the world!

waitplanwp
Автор

Could you please upload the file to the channel, it will be very helpful, your solution is amazing!

waitplanwp
Автор

Dear Abiola,
I made a modification to your formula, sorting by Payment Type and displaying only the essential data:
=LET(criterion, P1, formula, FILTER(dataset, CHOOSECOLS(dataset, 1)=criterion, ""),
contuniquePT, COUNTA(UNIQUE(CHOOSECOLS(formula, 3))),
sumTotal, SUM(CHOOSECOLS(formula, 6)),
hstack, HSTACK("", "", contuniquePT&" Payment Types", "", "Gran Total:", sumTotal),
VSTACK(DROP(SORT(VSTACK(formula, hstack), {3, 2}, {1, 1}), 1), hstack))
I hope you enjoy. 🤗

JoseAntonioMorato
welcome to shbcf.ru