Announcing LAMBDA Helper Functions: Lambdas as arguments and more

Chris_Gross 

Thank you for expediting the Beta Channel rollout this time.  You would have had some very unhappy users if it had dragged out!

cc ACook84 , SergeiBaklan 

lori_m 

You are a very brave man to make any predictions as to how this experiment will go!

I woke up to MAP and couldn't resist trying it.

Anonymous
= MAP(month,
    LAMBDA(m,
      AVERAGE( 
        FILTER(Temp, MONTH(date)=m)
  ) ) )

Named
= MAP(month, AVERAGETEMPλ)

The joy for me is that I was able to dispense with the concept of relative referencing, which I have despised for a number of years, regarding it rather as 'the poor man's array'.

It may have been a moment of joy for me, but I can't see the majority of spreadsheet users changing the practice of years anytime soon.  I rather expect to see a very long period in which there are two Excel communities, one embedded within traditional working practices and the other embracing the new.  Add to that, the increasing use of AI to support program development which may mask the differences, and it will be an interesting challenge knowing how to answer any given user question on the various Excel forums.