When and how to use ByRow and ByCol functions in MS Excel

In this video, you will understand the proper use case for ByRow and ByCol functions that are now available in Production stage in MS Excel 365.
You will also learn the following:
The correct syntax for these functions
Calculating column or row wise sum, average or count of a dynamic array
Wrapping the functions inside a super function ( SumArray)
Introduction to Switch function
Introduction to Advanced Formula Editor
The underlying files is available for use in the following location:
www.profectusa...
(item no. 4)

[@Nevir202]

Wow, this is really cool, and gave me a lot to think about. I'm wanting to do something weird, to output the data from a table in a more conversational text format. So what I am wanting, is a BYCOL that appends the col header to the cell contents, to use your example it would output in the first row: Product: Milk Biscuit - UDS: 666.70 - GBP: 510.20 - EUR: 625.00 Every row below would be the same format. Is something like that doable? I don't see how to refer to the header in a way to tell it what I am wanting?

[@DS-yf2md]

As always, video content and your explanation is awesome ( reminded me of my EY training sessions). Just one very minor suggestion Vishwa, background music needs some change 😀

[@ProfectusLearning]

Thanks, DS. I tried a different background score for a change. Looks like it was a bad idea. Will definitely change it in the next ones

[@venkatasivakrishnaabburi3633]

How to use by row function if we have a condition to meet in the same row, let s say I have PNL and BS values in row and at end we want sum of PNL ,but BS at year end. value.

[@sampatadia5201]

Very good presentation. but terrible background music. Also you may reduce size of you picture in video after initial intro and put it towards bottom left corner and remove yellow circle around cursor.

[@ProfectusLearning]

Thanks for the feedback Sam

[@tarundakalia]

How to create dynamic heading like in the tutorial?

[@ProfectusLearning]

It was just a transpose function. You can download the file from here to check how it works: www.profectusacademy.com/practice-files (4th item)

[@xlrobot]

Good stuff, thank you!

[@tarundakalia]

@@ProfectusLearning Thanks, Sir. Everything worked, except the borders and other formats were missed. Unlike in your video, in my case, the borders didn't update and had to adjust other formats manually.

[@ProfectusLearning]

I did it with conditional formatting. A video on that will be out soon.