I have looked up the last argument a while ago. It's about how rows are sorted when there are multiple arguments.Say you have both the product and the color and then sort them in descending order by the values column. The hierarchy option would keep all the bikes together and the table option sorts by the value alone. I am in love with the function. Best thing since FILTER to happen to Excel.
@AccessAnalytic14 күн бұрын
Excellent, thanks for that
@Hello-bn2yc14 күн бұрын
This is just awesome... these dynamic array formulas have completely revamped excel. Thank you for the share.
@AccessAnalytic14 күн бұрын
Yeah so much good stuff there now !
@X1AbuBadr1X14 күн бұрын
nice its finally out ,, i was waiting for this update for months ,, thanks for the clarification
@AccessAnalytic14 күн бұрын
You’re welcome.
@chrism903713 күн бұрын
Thanks Wyn, I finally got these
@AccessAnalytic13 күн бұрын
Good stuff
@nazarkamal883114 күн бұрын
❤❤❤❤❤❤❤❤ Useful information
@jerrydellasala764311 күн бұрын
From the GROUPBY Beta help (not online yet): field_relationship Specifies the relationship fields when multiple columns are provided to row_fields. The possible values are: 0: Hierarchy (default) 1: Table With a Hierarchy field relationship (0), sorting of later field columns takes into account the hierarchy of earlier columns. With a Table field relationship (1), sorting of each field column is done independantly. Subtotals are not supported as they rely on the data having a hierarchy. (That's Microsoft's spelling of independently!)
@AccessAnalytic11 күн бұрын
Cheers, I think I need to see it in action
@sledgehammer-productions14 күн бұрын
I really enjoy dynamic arrays, but I can't seem to make them play nice with power query. I've tried to give the spilled range a name in the name manager (add the # to the upper left cell reference) and within the workbook that works fine. But when setting up a power query to that workbook, that defined name doesn't show up in the items to choose from. Would be "awesome" if that becomes possible.
@AccessAnalytic11 күн бұрын
Yes that would be good
@nibgrahi565113 күн бұрын
What is the usual time gap between current channel and semi-annualise channel?
@AccessAnalytic13 күн бұрын
Semi annual gets updates in January/Feb and July/Aug
@AnandPenmatcha14 күн бұрын
That is not available in enterprise version yet it still at 2408. Waiting for last one year
@AccessAnalytic14 күн бұрын
Next month 🤞🏼
@ennykraft14 күн бұрын
It's available for people on the current channel. Anyone on the monthly channel will get it next month. But if your company is cautious (like a lot of my clients) and are on the semiannual channel, it can take quite a while till you get it. Hopefully you'll get these functions soon. They're absolutely awesome.