Joe McDaid

Product Manager on Microsoft Excel. Grid's for the win.

[Joe McDaid @jjmcdaid]

@wynhopkins @msexcel Thanks for all the support and feedback! Happy its coming in handy. ❤️

[Guido van Rossum @gvanrossum]

Yeah, so I helped the Excel team with this. Excited that it's out! https://t.co/zH1o2Fiaad

[Joe McDaid @jjmcdaid]

@gvanrossum Thanks for all the collaboration and learnings. It was a pleasure getting to work with you on this project.

[John Lam @john_lam]

Python in Excel is now a thing! Python is now a peer of the Excel formula language and you can mix both languages seamlessly in the Excel grid. Python runs on Azure and is powered by the @anacondainc Python distribution.

This was a multi-year collaboration between the Python team in Developer Division and the Excel team. It was a privilege of a lifetime to work daily with @gvanrossum @ahejlsberg @keyurp32 @jjmcdaid @zooba @iritkatriel @oterocarlos and a few other folks who don't use this site.

https://t.co/5FQ5DcjhHA

[Joe McDaid @jjmcdaid]

@xenophin @DayTechHistory 😂

[Joe McDaid @jjmcdaid]

I'm excited to announce that the latest set of Excel functions are generally available. 🎉 They simplify common text manipulation tasks and unlock dynamic array scenarios.

TEXTBEFORE/AFTER, TEXTSPLIT, EXPAND, TAKE, DROP, V/HSTACK, CHOOSEROWS/COLS, TOROW/COL and WRAPROWS/COLS.

[Joe McDaid @jjmcdaid]

@Mark_Baker Hmm, I’ll get the docs fixed. That was actually a late breaking change, we realized the inconsistency and then aligned the functions after initial release.

[Joe McDaid @jjmcdaid]

@Arrqh Any luck? I'm refreshing 4 or 5 pages and still nothing. :-/

[Joe McDaid @jjmcdaid]

@ehansalytics Thanks for the feedback!

[Joe McDaid @jjmcdaid]

We are bringing 14 new functions to Excel. These functions will help you manipulate text and arrays via formulas. TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK,TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, EXPAND, CHOOSEROWS and CHOOSECOLS https://t.co/ZmnlzrL5bm

[Joe McDaid @jjmcdaid]

@benlcollins Thanks! I’m definitely a fan of the entire spreadsheet ecosystem and the innovation it drives. 😀

[Joe McDaid @jjmcdaid]

@ijgore Semi annual enterprise forks every 6 months. LAMBDA didn't make the most recent train but it should be in the next. There is also a monthly enterprise channel that will get it sooner.

[Joe McDaid @jjmcdaid]

@IanCutress @anandtech @RyanSmithAT @anandshimpi @BrettHowse @gavbon86 All the best for your next career step. I'm selfishly hoping you'll still be producing content that is available to tech nerds like me.🤓

[Joe McDaid @jjmcdaid]

@navi_sv @ehansalytics Great question. Lambdas can have multiple variables. This one is simple, and it just has one which is named X. A more complex lambda could have many more, and the author could provide meaningful names to each to improve readability.

[Joe McDaid @jjmcdaid]

🆕Today we rolled out lambda function support to Excel users on the current channel. If you use dynamic arrays, I'd recommend starting with BYROW and BYCOL which can be used to aggregate rows/columns and spill the results. https://t.co/wBrQjl4VsH

[Joe McDaid @jjmcdaid]

@SteveDX_ We have a Monthly Enterprise Channel (MEC), which is a little delayed from the Current Channel (CC) that gets monthly drops. If you are on MEC, you'll need to wait a little long. That could be the next drop, but it could be delayed if we find a bug we want to address before MEC.

[Joe McDaid @jjmcdaid]

@MMolyneaux Did you inquire about sign on bonus before you turned them away? Also, worth checking if you can refer yourself and pocket the referral bonus too. :)

[Joe McDaid @jjmcdaid]

Solve your Wordle using Excel and Dynamic Arrays. Great video @MrExcel! https://t.co/1d9dalW8FY

[Joe McDaid @jjmcdaid]

@MMolyneaux My grinder is nearing 4 years, hadn’t thought of replacing burrs. Now to do some burr shopping…