• Hot Topics

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 1 2 3 3 3 3 3 2 3 3 3 3 2 3 3 3

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

This thread is current as of December 8, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel


© Copyright 2018 excelarticles.com.