DEV Community

loading...

Excel Formulas to Create the Running Count Group by N Size!!

excelgeek profile image Andrews Originally published at geekexcel.com on ・3 min read

Assume that you have a list of names, and you need to group them based on the given size. How could you deal with this task in Excel? In this article, I introduce some formulas to create the running count group by N size in Excel. Let’s step them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Running count group by N size
Running count group by N size

Generic Formula:

  • Use the below formula to group the values based on the given criteria.

=CEILING(COUNTA(expanding_range)/size,1)

Syntax Explanations:

  • CEILING ** – In Excel, the **CEILING function rounds a given number to the nearest specified multiple.
  • COUNTA ** – This function is used to counts the number of cells that are non-empty and returns the output in numbers. Read more on the **COUNTA function.
  • Expanding_Range – It represents the input range.
  • *Size * – It is the criteria value.
  • Comma symbol (,) – It is a separator that helps to separate a list of values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image. Here we will show how to create the running count group.

  • First, we will enter the input names in Column B , and the size of the group is given in Column D.

Input Range
Input Range

  • Then, apply the above-given formula to the formula bar section and press the “Enter” key.

Enter the formula
Enter the formula

  • Finally, it will display the result in the selected cell.

Result
Result

Conclusion:

Hope you like this article on how to create the b. If you have any doubts/suggestions, don’t forget to share them with us. We will assist you. Thank you!! To learn more, check out Geek Excel *and Excel Formulas *!!

Related Articles:

Discussion (0)

pic
Editor guide