6 Confusing Functions Having "ROW" in Their Names - SIMPLIFIED

There are many Excel functions that include the word "ROW" in their names. Some, like ROW and ROWS, have been around for a while, whereas others, such as TOROW, BYROW, WRAPROWS, and CHOOSEROWS are relatively new, often causing confusion because of their name although they have distinct actions.
In this tutorial, I will clarify these functions with straightforward examples and demonstrate how to apply them in real-world scenarios.
Jump Directly to the function you want by clicking on the timeline:
The ROW Function 00:43
The ROWS Function 05:58
BYROW Function 08:52
TOROW Function 13:32
WRAPROWS Function 15:22
CHOOSEROWS Function 21:58
There is another set of 6 functions having the word COL in their names:
COLUMN
COLUMNS
TOCOL
BYCOL
WRAPCOLS
CHOOSECOLS
The concept is exactly the same but it works on columns not on rows. We explored some of them.
#################################################################################
The OfficeInstructor Centre Offers Corporate Training to companies and organizations of all size, in North America and across the globe. To book a training check our course catalog at:
www.Officeinstructor.com

[@IvanCortinas_ES]

When Excel becomes art, Nabil Mourad appears. An exercise in precision and wisdom. Thank you, my friend.

[@Officeinstructor]

OMG, you took me higher than the stars with your nice comment. Thank you so much

[@Luciano_mp]

Beautiful work! Very useful! Very well explained! Thank you very much Nabil!

[@Officeinstructor]

Glad you liked it!

[@VijayKumar-zd7ou]

The way you explain anything is very good

[@Officeinstructor]

Thanks for the compliment

[@reng7777]

Beutiful formulas! thanks for the video!

[@Officeinstructor]

You're so welcome!

[@khanabdussabur8604]

Awesome Nabil! Thanking you.

[@Officeinstructor]

Glad you liked it!

[@nadermounir8228]

This is an epic video. Thank you for your this amazing tutorial :)

[@Officeinstructor]

You're very welcome! I am so glad you liked it

[@nadermounir8228]

@@Officeinstructor it was awesome

[@Michael_Alaska]

Well explained, thank you. As Scooby-Doo might say "Rut-Row".

[@Officeinstructor]

Thanks for watching

[@johnborg5419]

Thanks Nabi.

[@Officeinstructor]

You're welcome

[@alializadeh8195]

Thanx

[@Officeinstructor]

Welcome

[@therathores]

Hey great video, very well explained. Can we get this excel for reference? Thanks

[@Officeinstructor]

Thanks for watching. Sorry the exercise file was created for a client and cannot be shared

[@m.bouguerra]

my friend I send you the link of the exercise file... docs.google.com/spreadsheets/d/1KnXzcl8HCu_UZPhagTQc2NwVxHiioiEA/edit?usp=sharing&ouid=100909622223289316137&rtpof=true&sd=true

[@kebincui]

👍👍🌹🌹

[@Officeinstructor]

Thank you

[@OarN-s6d]

New

[@Officeinstructor]

Hope it helps