How to divide column into equal parts

%3CLINGO-SUB%20id%3D%22lingo-sub-3178501%22%20slang%3D%22en-US%22%3EHow%20to%20divide%20column%20into%20equal%20parts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3178501%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20figure%20out%20how%20to%20save%20some%20time%20on%20massive%20amounts%20of%20data%20by%20dividing%20a%20column%20into%20equal%20parts.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStep%201%3A%20I%20have%20hundreds%20of%20stock%20tickers%20per%20sheet%2C%20and%20hundreds%20of%20sheets.%20I%20create%20a%20%22countif%22%20function%20to%20count%20the%20number%20of%20tickers%20in%20a%20column%2C%20then%20divide%20that%20into%204%20parts%20while%20grouping%20all%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEX%3A%20if%20there%20are%20232%20tickers%2C%20I%20will%20have%20the%20following%20numbers%2058%2C%20116%2C%20174%2C%20then%20ending%20in%20232%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20a%20different%20column%2C%20I'm%20trying%20to%20find%20a%20way%20to%20assign%20%221%22%20to%201-58%2C%20number%20%222%22%20to%2059-116%2C%20%223%22%20to%20117-174%2C%20%224%22%20to%20175-232.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20hundreds%20of%20sheets%20to%20do%20this%20over%20and%20was%20hoping%20there%20was%20a%20shortcut.%20Any%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20wonderful%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3178501%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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