Max ascending by name output not to exceed 7 records?

nihou

Hello, 

I am trying to generate output files based on a key item, "Name".  I need to limit each output to 7 records.  I would also like the output file names to be numbered in ascending order by the key item as well.  I have attached a source document with output tabs, however I would like the output o be files vs tabs.

Max ascending by name output not to exceed 7 records

Output Testing with Max Records.xlsx

Luke_C

Got it, take a look at this method:

It will count how many records are present for each name, and the multi-row formulas put them into groups based on those counts. If the total count for the group exceeds 7 it places the name into the next group.

Then for the separate files, you can use the formula tool to derive the filename. For excel files, you'll need to choose 'change entire file path' and choose the new filepath column. This is currently set to output to wherever the workflow is saved, but you can adapt that. 

New Workflow1.yxmd