Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

Original video from Mike Girvin provided here: https://youtu.be/n09E8VfwWFc

Written Instructions: http://www.xelplus.com/index-dynamic-range/

In his video, Mike Girvin at ExcelisFun provides a very elegant and neat solution from Bill Szysz to the following problem lookup problem:
.
The end result is to come up with a description column in Excel, that includes the number of sub-items within a main item and also provides the description of the main item.

My Online Excel Courses ► https://www.xelplus.com/courses/

This video builds on the existing video by providing an alternate method using the COUNTA, INDEX and MATCH functions.

The formula shown here uses Excel's COUNTA function together with the INDEX function to create a dynamic range to count. The index function is used to provide a cell reference to the COUNTA function for the position of the top range as well as the position of the bottom range for each subset.

Excel's match function is used to look for or match for the first non empty cell (non blank cell) to provide the location of the top cell address and then the match function is used again to match for the first empty cell to provide that address for the bottom of the range to the COUNTA function.

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

#excel