This NEW Excel Function is NOT for Beginners (unless you watch this)

[@navneetrk70]

Thankyou Sumit. This is very useful for us. Like to track 7 consecutive days of working or consecutive repeat defaulters. Earlier we had to use some complicated nested countif formulas.

[@legolife3012]

Good explanation. Basically the formula says, from 0, scan the given range, while scanning SUM the range.

[@trumpexcel]

Yes, if you're using the SUM function. Else, can also be used as shown in example 3, where a counter is used that increments by 1 whenever a cell matches the given criteria.

[@AdrianPalmer-n4j]

Very helpful. The only way I've done this before is to use a recursive lambda function and offset, but scan makes it much easier

[@nadermounir8228]

Very interesting video thank you Summit

[@waitplanwp4129]

graet video!❤

[@sekhar6106]

Sir, thank you for explaining the formula in detail. Need to learn LAMBDA first, then practice SCAN to get the results shown in the video.

[@trumpexcel]

You can learn about LAMBDA from here - kzbin.info/www/bejne/b3iXenyPfd6GpcU

[@carlo_migliari81]

Great video! Next time can you explain REDUCE function?

[@trumpexcel]

Yeah, have it on my list for make videos for all the LAMBDA helper functions, including REDUCE

[@dineshwagle9832]

Mind-blowing

[@rjkumar-s7q]

Can you please create video, alternative way for Solver add in

[@tamersalem7542]

❤ fantastic ❤

[@ZeeSum23]

Ah, now it makes sense. Wasn’t sure what it could do.

[@Bhavik_Khatri]

Awesome

[@Garimaish]

Wow 😮

[@teoxengineer]

The 3 th example didn’t spill, I think byrow function is more efficient than scan

[@trumpexcel]

This formula will make it spill =BYROW(B2:G6,LAMBDA(a,IF(MAX(SCAN(0,a,LAMBDA(counter,curr,IF(curr="Absent",counter+1,0))))>2,"Investigate","All Good")))

[@ManthaarJanyaro]

1st Comment ❤

[@kebincui]

👍👍