How to build custom functions containing range references using Lambda?

https://support.microsoft.com/en-us/...a-ccbf254b8b67

https://techcommunity.microsoft.com/...s/ba-p/1925546

https://www.wiseowl.co.uk/blog/s2840...ions-excel.htm

Or just Google: excel lambda function

Hello Vivek2705 and Trevor.

I can't get it to work. According to my Account I am current on my O365 updates.
I keep getting #NAME? errors.

I will be checking back from time to time and checking my current updates. I just tried manual update anyway and was informed I am current. (Insider.....I am supposed to get updates once or twice a month.)

Which Insider channel are you on? You may still need to be in the Beta channel - even then MS frequently release these things piecemeal.

Thanks rorya.
I was on 'Preview'. Just switched to 'Beta'. Same deal.

(Gosh I hate getting my meals in pieces!!!!!)

I just joined but I had to run a couple of updates before it worked. So maybe you just need to check for updates?

Thanks Trevor.

Still not updating.

My last name is at the end of the alphabet so I'm used to this. LOL

Mmmm, well my name's quite a way down the alphabet. I wasn't on the Insider Program ... I just went and ticked the box and then checked for updates a couple of times.

These things can be quite random. I’ve had different PCs get different updates even though both are using the same account.