Category:

Course Description:

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. 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. Course Length: 16:54 minutes Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.