How You Can Actually Use the NEW Excel BYROW & BYCOL Functions

Have you used the new Excel BYROW and BYCOL functions? Microsoft released new Excel Lambda Helper Functions. In this video I'll introduce 2 of these functions and how you can use them with a practical example: BYROW and BYCOL.

These functions are great if your analysis is based on entire rows and columns. For example if you'd like to count how many times you went over target value and the target value is in rows or columns. Or you'd like to sum the values in a row or column if the value is over a certain threshold. For these cases you can use BYROW and BYCOL. They're actually easy Excel functions to use. The last argument for lambda can seem confusing but it's basically any function you want to use on the entire row or column. This video will give you some ideas.

00:00 New LAMBDA functions available in Microsoft Excel
00:53 How to Use Excel BYCOL Function
05:55 How to Use Excel BYROW Function
07:24 Wrap Up

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[andrewmoss]

The formula bar definitely needs an upgrade now we're writing long complex programming code!

[caswarupghosh]

You are a magnificent teacher, who believes in updated technology and shares stuff

[cenevspeed_CARS]

Is this wonderful or what😱? I never knew what Lambda was until seeing this video! And these new functions really do simplify the process by preventing copy and pasting of the function. With just one function you can get the output from multiple rows and columns 😎

[dermotbalson]

I have used lambda in a spreadsheet with 16 sheets for different states and product lists. The key formulae were identical except for a couple of parameters. Putting those formulae into lambdas with parameters, removed all the complexity from the worksheet itself. To me, a lambda is the equivalent of what we do when programming. If we find ourself repeating code, we write a separate function for that code and call it when we need it, which is both simpler and safer.

[juanpablorossi]

Your content is brilliant Leila, I hope to share my work with you, obviously and it is very clear that I would learn much more from you, but my experience is that you always learn when you share knowledge. Thank you for such

[mattschoular]

Thanks Leila. With all of the "newer" dynamic array functions as well as Lambda functions, it really triggers me to evaluate my work flow and spreadsheet design. The largest obstacle preventing a shift is the inability to share files with non MS365 users. Thanks for sharing...

[Krazycat]

Yes I will be using this I just opened up a kitchen and have many many different types of of spreadsheets keeping track of different types of data thank you very much

[FunkyShufflerz]

I don't work with excel that much, but every time I see a new video I get so excited.

[bryanaero]

Thanks. Just when I think I know everything about Excel, I can learn 10 more things by watching one of your videos.

[olawalesolomonegbewole]

My respect for you has always been very deep and I have benefited immensely from your videos for many years now.
Thank you Leila for doing what you do.
God bless you.

[rimantasdanilevicius]

What I missing is recommendation or examples of what other options there are in Excel, and opinions which is the most practical. But as some one comment - you always up -to-date and professional!

[bharathchellappa]

Omg.Your presentation makes easy to learn the complex functions.The thirst to learn Office skills from you keeps bringing me here anytime.Thank you so much.

[vaggau]

I can definitely see some use for them, I don't think I can see them allowing us to do anything we couldn't before but it definitely makes formulas more concise and it's often useful to get an array output rather than how I'd usually do this which is autofill the formula across then filter the information from it separately.

[Jahspecs]

This is awesome… the thing about excel is it has so much functionality that often times you don’t need it, don’t use and forget it even exists! However, no doubt, is super awesome!

[yamiyeo]

Thank u for your informative step by step tips & tricks -

(1) how to share screen to do presentation over MS TEAMS and other tips
How to print presentations slides within A4 size

Look forward to it

[Ronnet]

I can see myself using these to create filterable ranges for graphs. I know there are other ways to make this but this seems easy to make (and more importantly) to maintain.

[imbly]

I've only started watching your videos a few months ago and already you're one of my favorite youtubers who's taught me so much. This video in particular is exactly what I needed today to solve a complicated problem. Keep it up :)

[adelaidekusorgbor]

Hi, this was very intuitive and am able to process a huge amount data comprising 12, 583 rows and 144 columns just in seconds. Great job and thank you so much. My MS Access application is also confirming the same results output.

[danijeldz]

4:13, "just keep it simple", you are great:D
thank you for all the updates you made for all of us. All we knew about Excel in the past period needs to be revised.

[sketchtwenty]

Another commenter spoke of using these functions along the many other new Excel features to rethink how sheets are designed. I agree and will slowly add these functions to my repertory.