How To Use The Scan Function in Excel

In this tutorial I show you how to use the scan function, also called a Lambda helper function. Although the definition seems confusing but with some examples you will find it very simple. Along the way, you will learn about the Reduce function as well.
You can read my step by step graphic article by clicking on the link:
officeinstruct...
If you like this tutorial, give a thumbs up and subscribe to support my channel.
To book a Corporate Training anywhere in the world, visit:
www.OfficeInstructor.com

[@IvanCortinas_ES]

Absolutely pedagogical, Nabil. It can't be explained better.
Thank you very much for showing these examples, as you perfectly explain the core of the function.

[@Officeinstructor]

I am glad you found it clear and helpful.
Thanks for watching

[@conradblume4274]

I love this channel, I ALWAYS learn something useful!

[@Officeinstructor]

I'm glad you find value in my tutorials. Thanks for watching

[@nadermounir8228]

Very well explained 👏 Thank u Nabil for your hard work

[@Officeinstructor]

So nice of you. Thanks

[@Locomaid]

Awesome, Nabil!

[@ambkumar]

Thanks for sharing info.. Excellent content and delivery... 💌

[@thebhaskarjoshi]

Very well explained

[@Officeinstructor]

Glad you liked it and thanks for watching

[@TylehurstXL]

Im still unsure why I would ever prefer scan functionality over traditional functions

[@SolomonKinyanjui_sk]

This is amazing.

[@Officeinstructor]

Glad you liked it

[@JoseAntonioMorato]

My friend, Nabil,
The syntax of dynamic functions is changing and now, in most of them, it is no longer necessary to establish the variables of the LAMBDA function, but only the calculation function:
=SCAN("",A2:A12,CONCAT);
=REDUCE("",A2:A12,CONCAT)
=SCAN(0,A2:A11,SUM);
=REDUCE(0,A2:A11,SUM) 🤗

[@Officeinstructor]

Hello my Friend, I don't know about that but the idea is amazing.
Unfortunately, it does not work for me. I even copied and pasted your functions and I get a #Name error.

[@richardhay645]

@@Officeinstructor A slow rollout of Eta LAMBDA functions to Insiders is underway. Not sure why it is so slow. The new insiders release also includes 2 new function GROUPBY and PIVOTBY which are also Eta LAMBDA s. Not sure why the rollout is very slow. See videos by Mr Excel and by Mike Girvin. The Eta LAMBDA let you omit the carrying variables like your x and y and also let you specify the function by its Defined Name.

[@JoseAntonioMorato]

@@Officeinstructor My friend, Nabil,
I am subscribed to the Excel Insider, beta channel, and this news came along with the launch of the GROUPBY and PIVOTBY functions.
=SCAN("",A2:A12,CONCAT)
A
AB
ABC
A B C D
ABCDE
ABCDEF
A B C D E F G
ABCDEFGH
ABCDEFGHI
ABCDEFGHIJ
ABCDEFGHIJK 🤗

[@Officeinstructor]

@@richardhay645 Although I have the Beta insider version of Excel I do not yet have the GROUPBY,PIVOTBY or Eta LAMBDA. everyday I check for updates but unfortunately, I am not among the lucky users who received them.

[@Officeinstructor]

@@JoseAntonioMorato Although I have the Beta insider version of Excel I do not yet have the GROUPBY,PIVOTBY or Eta LAMBDA. everyday I check for updates but unfortunately, I am not among the lucky users who received them. So I used what I have for this tutorial

[@GeertDelmulle]

Good stuff! :-)

[@Officeinstructor]

Thanks for the visit

[@richardhay645]

Great!

[@Officeinstructor]

Thank you

[@ALG_1983]

Thanks

[@Officeinstructor]

Welcome

[@JonathanGarza-cn8ym]

how do you even know this... impressive

[@alializadeh8195]

Thanx

[@kindyletutorials7197]

10000000000000000000 thanks .

[@Officeinstructor]

100000000000000 Welcome

[@patricknyamu6110]

nice

[@Officeinstructor]

Thanks

[@BraveHeart-ht8zf]

HOW TO FORMULA FILL DOWN COLUMNS A & B AT ONCE

[@Officeinstructor]

Select the Cell (s) having the formula or function and double click on the small square in the lower right corner.

[@geerliglecluse5297]

Reduce function just gives you the sum of the values. Can be done with the good old "SUM" function. Why all this needless complexity?!

[@Officeinstructor]

This tutorial is about the Scan function, I included a hint about the Reduce Function (as bonus). At a glance you might be correct but actually the Reduce function when used as a support function to a much more complicated function (within a LET function), cando things way beyond what a Sum can do. May be I create a video on the Reduce function when I get a chance.

[@Pankaj-Verma-]

Yes, please.

[@geerliglecluse5297]

@@Officeinstructor Thanks for your reply. I am looking forward to a video explaining the advantage of using Scan/Reduce function combined with LET as opposed to the SUM function.