Excel Magic Trick 1503: Free Book Give Away EMT 1493 – 1496 RAND & VLOOKUP Functions

In this video we give away a free book after the voting about which method was preferred in Allocating Header Invoice Amounts to the Line Item Transaction Table in these videos:
Related Videos:
EMT 1493: Excel Formulas & PivotTable: Allocate Invoice Header Amounts To Transaction Line Item Table
EMT 1493 Part 2: Excel Array Formulas Allocate Invoice Header Amounts To Transaction Line Item Table
EMT 1494: DAX & Power Pivot: Allocate Invoice Header Amounts To Transaction Line Item Table
EMT 1495: Power Query: Allocate Invoice Header Amounts To Transaction Line Item Table
EMT 1495 Part 02: Power Query w Group By Rows: Allocate Invoice Amounts To Line Item Table
EMT 1496: Power BI Desktop: Allocate Invoice Header Amounts To Transaction Line Item Table
EMT 1497: Vote For Your Favorite “Allocate Invoice Header Amounts To Transaction Line Item Table”

[MrXL]

Whoo-hoo! I love the Alternate Drag-And-Drop menu trick at the end!

[johnborg]

Congrets to Pierre. Wish you could do more of these Mike.

[OmarLopez-ddyh]

Thanks for your support continue doing this kind of videos. Really helpful. Congratulations, I'm from Mexico

[barttitulaerexcelbart]

Thanks for this series. Interesting to see all those different solutions for one and the same problem. I really like these series. Like good old TV series, guessing what comes next week..;)

[GeertDelmulle]

Wow! A mini-series like this one really is more than double the fun! Good for PQ to win the stats!
BTW: today for work I had to pull all the stops in PQ in order to get to a proper star schema data set.
It involved 6 tables, two which were fact tables (and one of those was actually cross-tabulated to begin with).
I basically had to apply most of the things we learned in this series (and some more from earlier videos)!
I showed it to some collegues and explained the PQ steps, the last three of which were expand column (subtables), two of which were nested. In the process of explaining, in the reputation domain, I got promoted from Guru to God level. ;-)
(But then again they are easily impressed by a couple of slicers ;-)
So, in conclusion: thank you very, very much, Mike. The knowledge gained was put to good use, and your knowledge-sharing willingness is legendary. I salute you!

[krn]

Thanks Mike. Cool to see my name atop the list. :)

[ismailismaili]

Oh my goodness thank u so much for your give away

[mohamedchakroun]

Cool thing :-) we are all winners Mike by following you and learning many things from you :-)

[vida]

Prize draw is also fun like your other videos. By the way, when advanced filter message pops up, just click OK and select range and there is no need to have headers in bold

[ApplyEval]

I did not get how come to the 'secret' menu at the end. Could you explain it?

[MalinaC]

A lot of fun watching the series and the RADN & VLOOKUP fun :). Thank you Mike!

[brianxyz]

Did the people who voted "Other" indicate what methods they prefer?