Very nice session. I learned some new things: 1. The way to use checkboxes in the FILTER function, 2. The ARRAYTOTEXT function ( I did not know at all) and 3. The way to use function to get the numbers from the last year period by using SEQUENCE. Thank you guys
Cool, thanks for commenting with your findings, Ismael. The ARRAYTOTEXT function is now included as one of the 17 functions that GROUPBY and PIVOTBY can do. So that is a good find (if you need it one day)
Thanks Alan and Niel. I don't have the checkboxes yet, but the example of the selection of the header/field was very interesting, so I tried this with a slicer, (I first converted this to a table of course) Then I used this function to get the 1 (for selected) and 0 (for deselected) : =IF(SUBTOTAL(2;[@fieldnr]);1;0). I was supprised that this worked: so slicers to select columns....😉
Hi Neil, I think to get the column ns to select you just can use: FILTER(R3:R10;Q3:Q10), that give an array with the numbers, no need for Arraytotext.. and value...😉
Excellent session. Thanks Alan and Neil
Thanks, Kebin. My pleasure.
Very nice session. I learned some new things: 1. The way to use checkboxes in the FILTER function, 2. The ARRAYTOTEXT function ( I did not know at all) and 3. The way to use function to get the numbers from the last year period by using SEQUENCE. Thank you guys
Cool, thanks for commenting with your findings, Ismael.
The ARRAYTOTEXT function is now included as one of the 17 functions that GROUPBY and PIVOTBY can do. So that is a good find (if you need it one day)
This is awesome, thanks for uploading on YT Alan!
The VStack and Filter Combination @46:23 is awesome!
Yes, that was very cool.
You're welcome, buddy.
Thanks Alan and Niel. I don't have the checkboxes yet, but the example of the selection of the header/field was very interesting, so I tried this with a slicer, (I first converted this to a table of course) Then I used this function to get the 1 (for selected) and 0 (for deselected) : =IF(SUBTOTAL(2;[@fieldnr]);1;0). I was supprised that this worked: so slicers to select columns....😉
Hi Neil, I think to get the column ns to select you just can use: FILTER(R3:R10;Q3:Q10), that give an array with the numbers, no need for Arraytotext.. and value...😉
14:50
23:00
24:30
43:00
48:00
55:00
Please share Excel Workbook for practice. 👍
The Excel files are available in the video description.