How to divide column into equal parts

Occasional Visitor

Hi, I am trying to figure out how to save some time on massive amounts of data by dividing a column into equal parts. 


Step 1: I have hundreds of stock tickers per sheet, and hundreds of sheets. I create a "countif" function to count the number of tickers in a column, then divide that into 4 parts while grouping all sheets.


EX: if there are 232 tickers, I will have the following numbers 58, 116, 174, then ending in 232


In a different column, I'm trying to find a way to assign "1" to 1-58, number "2" to 59-116, "3" to 117-174, "4" to 175-232.


I have hundreds of sheets to do this over and was hoping there was a shortcut. Any ideas?


Thank you in advance for your wonderful help!


0 Replies