equally divided file

[armingrudd]

Hi,

The solution by @HansS works great. I think you should rank on Date and IDs then bin the table.

Or

If I have got you correctly and it is fine to remove duplicates then I think there is a straightforward solution for this:

@89trunks

2. the same thing as 1) but it counts desired number of rows and if for instance 7th is repeated n times it omits it and takes next single one. The next part will start with what is omitted ang goes on.

Using Duplicate Row Filter or GroupBy on ID and Date columns makes it possible to remove duplicates then you can do the same approach as before to divide the table.