Excel's NEW "#" operator is a game changer!

[@kevinroche5480]

This is a good new feature and you explained it perfectly. Spillburgs, LOL.

[@chandoo_]

Thank you Kevin 😀

[@cupakah5223]

That was hilarious haha

[@JoeLoffredo]

I've not used most of the functions in the video - quite the eye opener! And thank you for showing how to use them so clearly!! Your slogan should be "if you think Excel can't do, just Chandoo!"

[@chandoo_]

That is a good one :)

[@ricksegalCanada]

There is nothing more glorious than working in excel, taking a break, and having the EXACT how-to YT video pop up. This video is outstanding!

[@chandoo_]

Thanks Rick.

[@Tabriv7979]

Thanks!

[@chandoo_]

Thanks for the super Tabriv... 😍

[@sebghatulbarykhabaey6680]

I am following your lessons and teaching at least from 13 years ago. Thanks for your kind teaching.

[@chandoo_]

Thank you so much for being with me all this while Sebghatulbary ❤

[@sumantgirase]

Been following your tutorials since ages now. You never fail to amaze me. As clear as sunshine, that explanation! Beautiful insights.. Thank you.

[@chandoo_]

Wow, thank you!

[@shubhampaul790]

Why I'm Not Able to use the # Function on me latest Excel ​@@chandoo_

[@sukoi2113]

Recently i used it with filter for validation. It saved me huge amount of manual tables. Doing so i just achieved a custom RLS in excel. Just magical.

[@shanobkottal3633]

Would love to see the example of RLS in excel

[@douglasbrown3354]

Outstanding video! You explain this very well and I appreciate your expertise and keen insight. All your videos have proven to be invaluable in my learning of Excel. Thank you, sir!

[@christophermartinez8853]

Agree. He does a great job of zooming in to the relevant area of the screen and using on-screen arrows, titles, etc

[@chandoo_]

Thank you Douglas. My mission is to make one million people awesome in their work every month.

[@ABQBobL]

Wow! What a clear explanation with simple examples. Plus your examples cover a myriad of uses. Not overwhelming or intimidating.

[@chandoo_]

Thank ABQB... :)

[@Adam_harrison666]

Using the Unique function in conjunction with the # operator for a dynamic data validation list which captures all the unique variables in that particular dataset is quite helpful... cheers!

[@dalmiadipak]

The functions were good, but your way of explaining was very good also. Keep doing the great work. It means a lot for many.

[@Matteous_YT]

Mind blowing stuff! Love your work Chandoo 😊

[@chandoo_]

Thank you so much 😀

[@JohnArktor]

This is eye opening! Excel truly is a great tool!

[@antoinebianchi6853]

Hello Chandoo, thanks a lot for all you're doing. Your helping me and my staff improve our skills.

[@wayneedmondson1065]

Great explanation! Thanks Chandoo!!

[@roopsvideo]

Superb and very useful. Your videos have become my reliable reference for excel queries instead of googling it :)

[@momol.9892]

I have been using the spill functions. It is so great to know how to summarize the spill range. Thank you!

[@chinaysolanki5258]

I was just looking for a good vidoe on # and you came out with it... Taught with real simplicity. Looking forward to more of such videos

[@chandoo_]

Glad it was helpful! Do let me know how you are using the # operator in your work.

[@canirmalchoudhary8173]

Great help on dynamic array and spill operator. End voice over is really enthusiastic

[@chandoo_]

Thanks Nirmal. Spill ranges are CRAZY powerful and useful.

[@Eristotl3]

Best excel tutorials on the internet

[@chandoo_]

Thank you 😍

[@ExcelWithChris]

Thanks my friend. Once again a great video and picked up cool tips and tricks. Regards from South Africa.

[@chandoo_]

You are welcome Chris :)

[@moemotala6758]

The great Chandoo. Great feature Nicely explained.

[@peterfconley]

I’m kind of shocked by how much I just learned..

[@314kam]

You are an absolute life savior. Thank you!

[@pektuspektus612]

So glad to see this # operator. Before I was thinking google sheets might be better than excel.. Excel is still the best :). Thanks Chandoo!

[@chandoo_]

Although Google Sheets has many exciting and powerful features, Excel is by far my fav too.

[@pektuspektus612]

@@chandoo_ thanks for the videos and all the excel knowledge

[@the_purple_mage]

Awesome! How has this NOT been in Excel until now?!

[@vijayarjunwadkar]

Very nice Chandoo! Thanks for the Index function tip especially! Loved the "Spillberg" pun! 🤣

[@chandoo_]

You are welcome Vijay.

[@Falkland82]

Great. I had some problems at beginning to follow the process, but after get to speed it was amazing. Well done Chandoo.

[@cherianiype]

FFAAAAANNNTTTAAAASSSSTTIICCC STUFF CHANDOO!! Dhanyawaad!

[@chandoo_]

Thank you Cherian. 😎

[@andreatorriglia8010]

Amazing use of multiple functions!

[@anushas3520]

Hi sir... watching you everyday has become my obsession... My online guru every single video of yours i have watched... Is more precious than anything in this world... I have converted my day to day (hours -days) work into refresh buttons.. now .after this i have gained so much confidence kudos sir

[@chandoo_]

So nice of you Anusha. 😊

[@stevenlagoe7808]

Just like all your videos, this was soooooooooo clearly explained. Well done, and thank you!

[@chandoo_]

Thanks Steven 😀

[@hariniharnath9932]

Hello Chandoo, great video. Superb examples. Awesome explanation 👏.

[@kaskalo2]

Omg, thank you so much. I ran into this by accident (youtube is reading my mind). I have a list based off a list. So from one option in first list I have 2 results. But second option has maybe 10. So my second list has to have maximum of 10 fields. Meaning, when you select first option you get 2 results and 8 white spaces. And this thing solves it and makes it so neat 😍😍😍 Thank you very much for this video!

[@arnoudvanrooij]

You make work so much easier. Thanks!

[@MrHonda52]

As ever- brilliantly presented

[@shriram8088]

Excellent video Chandoo. You have explained each and every points. Thank you!

[@chandoo_]

Glad it was helpful!

[@DEtchells]

Wow, I had no idea these functions existed! Super-powerful, thanks!

[@chandoo_]

Welcome to the brave new world Dave :)

[@MrAloha]

Woo-hoo! This is my favorite Chandoo video so far. Excellent! 💪😁🌴🤙

[@chandoo_]

Wow.. thank you Billy 😀

[@kandasamy1006]

Clear Explanations as always. Thanks Chandoo.

[@chandoo_]

My pleasure!

[@Jompa10]

Your videos are amazing man! I love this! It is super helpful, explained nicely and quite calming to watch in fact. Thank you so much 🙌🏻

[@chandoo_]

Glad you like them!

[@shashibhusanpandit7188]

Outstanding video. Your knowledge and skill of delivering is awesome. Thank you so much sir for the information.

[@chandoo_]

Thanks and welcome

[@srmchinni3]

This is awesome. All your videos on excel are brilliant. Helping me a lot in my office.

[@petersmith4914]

Fantastic! I always learn so much on your channel and it gets me thinking about new ways to do things.

[@chandoo_]

My pleasure Peter. Do let me know what awesome things you are doing with the # operator.

[@petersmith4914]

@@chandoo_ Still looking to utilize this in the reporting I do. I currently use pivot tables behind the scenes to provide users slicers to manipulate complicated data. Love your work, keep it up!

[@Guilopes99]

Great tip on the index + spill range. Smooth

[@chandoo_]

Glad you liked it!

[@jdray]

I learned so much watching this video. Thank you.

[@carloszuniga5680]

Muy buen video, gracias por compartir tu conocimiento. Saludos desde Punta Arenas, Chile.

[@yuthakrainarong265]

Great skills, great video. Countless global productivity.

[@trippb3]

Thank you for putting all this info together. It will help simplify and perfect a spreadsheet I recently created that's poorly done with pivot tables.

[@chandoo_]

Glad it was helpful!

[@clay4gli]

Great video - I get it now. Great tip on using the Index function!

[@VincentPendley]

Thanks, this will come in very handy. I appreciate your hard work on these videos. :)

[@broncokulicka]

You're videos are amazing. Great content, thanks so much.

[@chandoo_]

Glad you like them!

[@daninisco]

Thanks a lot Chandoo; and excellent video as usual.

[@sudhasomasundaram1509]

Once again, an incredible video beautifully explained.

[@chandoo_]

Glad you liked it!

[@bobwhelan5644]

Great demo Chandoo - this is gonna help me no end!

[@gonzalorengifo1031]

Keeping awesome Chandoo!

[@larryngo11]

This is great! Hoping to use some of these helpful tips with spill

[@ExuberantGoggles]

Fantastic video. Love the way you framed it around building more dynamic/robust reporting tools by using spill, instead of just saying hey look what spill can do. I would have been impressed seeing the spill operator do it’s trick ( I’ve just learned about the concept of spill recently). but I would have completely missed why spill would be a better long term choice than naming ranges

[@chandoo_]

Thanks EG. When I say "become awesome", I really mean it 😎

[@KunaalNaik]

Saves tons of time! Thank You :)

[@chandoo_]

You're welcome!

[@dhananjaypinjan2643]

It's really advanced, fantastic and awesome ..thumbs up ...thanks...

[@chandoo_]

You are most welcome

[@johnholland9371]

I had no idea I needed to know this! I can already think of several ways this can simplify some issues for me. Thank you very much.

[@chandoo_]

Glad it was helpful!

[@AriinPHD]

Woah this was a really great video! Informative and funny. Thanks for explaining the spill range operator. Very useful!

[@padynz9869]

Very informative and lucidly explained. Thank you very much.

[@chandoo_]

Thanks Pady...

[@geekatari4391]

This is just what I needed for a sheet that holds all shifts in my job, and the shifts have been changing and I have to manually add them and then manually change the lists and data values. I am going to put it in practice and impress my boss! 😁

[@jrobinson8898]

Thanks for sharing this great feature!

[@msm023132]

Great video. Good examples with clear explanations!

[@kg.507]

Great info, greetings from Panama.

[@chandoo_]

Thanks for watching KG.

[@davesmith4106]

Great Videos Chandoo! Very helpful, as ususal.

[@seshendrakk]

Chandu Garu, Thank you so much for your amazing tips!

[@shashirajusiddaraju4979]

Really a powerful features in Excel, thanks chandu for knowledge sharing ☺️

[@chandoo_]

You're most welcome

[@samueldionne2451]

Very neat! Great Explanation

[@scottyd84]

Excellent tutorial, thank you.

[@kebincui]

Your explanation is very good and clear, also nice background music. Thanks Chandoo! 👍👍🌹🌹

[@turbalejo4999]

Great stuff spill range...Thank you...

[@lorenzoladejobi8701]

Very educative ! . Thank you Chandoo.

[@jesus21282]

that is INCREDIBLE, THANK YOU

[@VishalKumar-kv3dp]

Absolutely mind-blowing.....!

[@paulcompetente4329]

Love your contents Chandoo, keep it up sir🍻

[@ranaganguli2892]

I have no word.. it's too good..

[@pondyanand]

Great stuff ! Very well explained & good examples too !

[@chandoo_]

Glad you liked it!

[@rdatta]

Very nice review and well framed examples. Well done!

[@prkchpsnaplsaws2322]

Great explanation... This will be very useful!

[@SethSaavedra]

Just found your channel and love the content. Smart, helpful, and concise. Thank you#

[@The_1two3]

Really awesome, thanks Chandoo... 😇

[@chandoo_]

My pleasure Kalpesh.

[@ericjhubbell]

Great explanation, thank you.

[@ashhadshamim8554]

Awesome Chandoo !

[@chandoo_]

You are welcome Ashhad.

[@venkatraghavanr5169]

Wow..really a good explanation. Learnt something new through your video. Thanks

[@chandoo_]

Glad it was helpful!

[@shellbackbeau7021]

Awesome video! So glad you shared!

[@chandoo_]

Glad you enjoyed it!

[@chrismoran7955]

very clear explanations, thankyou so much

[@chandoo_]

You are welcome!

[@louiselane806]

Really useful, as always, thank you

[@Tantejuju65]

Excellent! Thank you!

[@dkerdnase]

nice tutorial mate!

[@geektarded]

Thank you for the great info!

[@gr8wh8orca53]

As always beautiful 🙏🏼

[@sambarajkanaveni7312]

Crazy.. Chandoo I am new follower ❤️💐

[@abbasmirenayat9813]

Thank you so much, your videos are awesome

[@chandoo_]

You are welcome Abbas.

[@sreejeshutube]

Really great knowledge for me Thanks chandoo

[@chandoo_]

Your are welcome Sreehesh..

[@markus_aurelius_888]

Great new tool 👍

[@teoxengineer]

Heloo Chando, Can we use "#" with "&" to refer some ranges? As far as I know, we can use "#" and "&" together inside Indirect function and I tried it, it works. (=Indirect("cell address&"#") However, without indirect, it doesn't work. Do you know about some usage of "#"and "&" together or is it possible?

[@chandoo_]

Interesting question. It seems any function that returns a reference (for ex. INDEX, OFFSET, XLOOKUP, INDIRECT) can all use # at the end. Assuming you have a spill range in B1, any of these formulas can RETURN it. =INDEX(A1:C1,2)# =OFFSET(A1,,1)# =INDIRECT("B1")# =INDIRECT("B1#") TBH, this is really mind-boggling and can open doors for some crazy implementations. Kudos to Microsoft Engineers who thought thru this possiblity.

[@DemoniqueLewis]

Great video, I learned a lot more than just the spill ranges. Unique and filter were new to me and very timely.