Premium Only Content

Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells
Feb 6, 2017 Excel Advanced Formulas & Features
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.
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.
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
-
John Crump Live
5 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
4.64K3 -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
330 watching -
1:00:56
The Tom Renz Show
9 hours agoThe War On DOGE Is ALSO A War On The Economy
18.8K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $1.26 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
25.8K3 -
1:56:29
The Quartering
6 hours agoAirplane FLIPS and CRASHES, Sean Duffy Slams Pete Buttigieg, & What Happened with Patriarchy Hannah
78K36 -
37:08
Standpoint with Gabe Groisman
23 hours agoDOGE The UK?! With Liz Truss
41.3K15 -
56:39
SLS - Street League Skateboarding
6 days agoHIGHEST SCORING KNOCKOUT ROUND OF ALL TIME! Felipe Gustavo, Dashawn Jordan, Filipe Mota & more...
30.6K1 -
14:26
Breaking Points
1 day agoWOKE VS BASED?: Saagar And Ryan Play A Game
31.9K6 -
5:29:58
SoundBoardLord
8 hours agoThe Red Dead Journey Continues!!!
29.2K1 -
1:17:31
The Officer Tatum
4 hours agoLIVE: Delta Airlines CRASH BLAMED On Trump, Ashley St. Claire Had Elon's BABY? + More | Ep 63
35.7K38