Excel: Count Rows Until Cell Value or Cell Value Changes


Experts, I'm stuck on a custom sort. I have converted the data into a tiered format, but now I would like to go through the "Level" column and determine the number of Level 3 entries in each group. For the following data I would like to return the number of rows in each Level 3 group. A named integer would be perfect. L2item Group 1 - 5 rows of Level 3 items L2item Group 2 - 4 rows of Level 3 items L2item Group 3 - 3 rows of Level 3 items Any advice is greatly appreciated! Data set:

Level L2 Item PN Description
1 1000 Truck
2 1 101 Apple
3 1 501 Dog
3 1 502 Cat
3 1 503 Snake
3 1 504 Shark
3 1 506 Tiger
2 2 102 Orange
3 2 601 Spider
3 2 602 Zebra
3 2
3 2
2 3 103 Banana
3 3 701 Fish
3 3 703 Pig
3 3 704 Cougar


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of December 08, 2014.


For more resources for Microsoft Excel