wow Paula I am really excited about Dynamic Arrays in Excel. They are totally awesome. Dynamic Arrays look like a real game changer. What I really love is that dynamic arrays work with most existing formulas

I use Excel 365. The improved collaboration and the mentions/chat feature are really fantastic and they make a real difference in work. How do I get the insiders edition?

Learn and Earn Answers: I like this new xlookup. I think it is a great advancement. There are a lot of improvements over the existing vlookup. that makes it more functional than vlookup and its more versatile.

I am working from Excel 2016. Excel 365 seems to have a lot of new features. Ideas looks amazing. I am still learning formulas and I can't create pivot tables yet. But from what you have shown, it looks

seems like DAX is a little complicated. Do all Excel formulas work in DAX? I need to learn all of the Excel formulas first I think before I can move on to this stuff.

intellisence in Excel has got a lot better and this problem with sum does not happen as much anymore. I can see a few other good uses of OFFSET - Daniel

Brilliant - thank you Paula. thank you also for the steem account, as you see I got myself going. Now I am ready to do these earning activities