## DEV Community is a community of 605,211 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

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

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

## 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.

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

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

## 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 *!!