Traditional Arrays or Office 365 Dynamic Arrays? Count Unique Dates Product Was Sold. EMT 1534

In this video learn two methods using Excel Spreadsheet Formulas to calculate a Unique Count of Dates Product Was Sold. Learn about the New Office 365 Dynamic Array Formulas and New Excel Calculation Engine or the Traditional Excel Array Formula Method. Learn about the new Office 365 FILTER Array Function, UNIQUE Array Function. See the standard Excel Functions: FREQUENCY, IF, SUM, ROWS and COUNT.

[sanjeevsoni]

Brilliant Mike, you have made life easy for many excel users. Thanks a lot

[edgiedapogi]

I love learning excel with your method Mike... Thanks again :)

[LeilaGharani]

Love dynamic arrays. So easy to use! Thank you Mike for another great tutorial.

[chrism]

The "Before" way is painful Mike! I can't wait until my Office 365 gets the new Filter function! Great video

[SyedMuzammilMahasanShahi]

Thanks for sharing this EXCELlent video Mike. This is amazing

[wayneedmondson]

Hi Mike.. way cool use of DAF vs. traditional array formula. I especially like the use of ROWS() vs. COUNT() for the performance advantage on a large data set. Had not thought of that before watching your video. Thanks for another clever and unique tip and technique. Thumbs up!

[richardhay]

Great way to show the advantages of using the new DAF. In your competition the winner is clear!!

[DavidNBerger]

Great! Thank you for your content and passion!

[nadermounir]

Great video especially the old school one :)

[ismailismaili]

thank you so much Mr. Mike that was great to know I really appreciate

[RossWalks]

Watching how easy this is with the new dynamic arrays is painful as I’m using CSE on a daily basis... come on Microsoft - let’s release this stuff already. Great video Mike.

[excelbear]

wow life is much easier~ the 1 dislike must really miss the array formulas

[mohamedchakroun]

I will use dynamic arrays for big data only :-) Mike, because daynamic arrays make us lazy to use the traditional function. Thanks for frequency function refresh to find unique values. Thanks a

[simfinso]

After watching this video I feel I am thousands miles away from this knowledge .I have to learn a lot of things .Great video

[ExcelStrategy]

The traditional CSE formula is rock solid and it will work in any Excel version this wins for me. Let me add that the construct with the new calc engine is not so easy at all.

[sandravukovic]

Cool! I haven't used the frequency formula that much, but somehow the logic of Office 365 version seems to be more, hmm, logical? :-) Anyway, thank you for both solutions! Will be trying them out "in the real world" soon.

[sevagbarsoumian]

Thanks Mike
One more time brilliant :)

[barttitulaerexcelbart]

Thank you Mike, this was a fair comarisson between the old and the new world with formulas. But "in the middle" there was/is an easier solution, not with formulas however: Just make a pivot and add the data tot the datamodel (checkmark), then put product on rows, and dates to values. It will count by default, but you can change this to ...."distinct count"....Although not formulas, it is faster to set up.... Greetings, Bart

[xBrianGG]

Great video.

The Count Unique formula would be even better if there was a way to spill it rather than copying it down the rows.

[pmsocho]

FREQUENCY was/is cool but now so many of those crazy "work with uniques" formulas are much easier to write and understand for a regular Excel user :)
Is it good or bad for us (folks who know Excel a little bit better than the average user)? :)