I need help with a formula that will find a text in a cell and filter it into 12 different groups (Zones)

[colling]

I need this formula to be able to find an item that is labeled "AUTOJOUR" under "Code 3" column as well as "Product" under "Product subtype" column. once it finds these criteria's I need it to divide it by 12. It's going from the highest Forecast/Month down to the least. My idea is that I want to evenly separate these items into 12 different "Zones" in order for me to be able to have an even amount of items spread throughout the warehouse going from the highest forecast to the least.

 

[Dermot]

I think what you're saying is that you want to sort the products by size of one of the columns (sales/stock?) and allocate them into 12 equal groups by size

One way to do that is to calculate how many products will be in each group (ie total number/12), let's call that N, then use the LARGE function to find the size of the product that is the Nth largest, 2 * Nth largest, 3*Nth largest, etc.

Then you can LOOKUP the group number for each product

 

[Dermot]

Try the attached approach

It ranks all the products by size (or whatever you want to group on), then allocates groups based on that rank

Grouping.xlsx