Adding a Group Number for every X amout of records

mnoisette
mnoisette used Ask the Experts™
on
I have an excel spreadsheet with about 30000 records.
There is also a column call "Group Number".
I would like to create a group number for every 150 records.
For example;
rows 1 through 150 would be "1",
rows 151 through 300 would be "2", etc.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Enter this formula in a cell in the group number and copy it down.

=int((row()-1)/150)+1

******edited*********

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial