Forum

Add Custom Count co...
 
Notifications
Clear all

Add Custom Count column that Groups Records in max of 500 for Each Group

2 Posts
2 Users
0 Reactions
90 Views
(@webbers)
Posts: 147
Estimable Member
Topic starter
 

I have a sheet/query named "WSCoreTeam". Column B contains email addresses and Column G contains an index (beginning at 1).  Currently there are 3,853 records on this sheet.  I would like to create a new column (Column H) as "Max Count".  I cannot figure out how to do what I want. I would like this new column to look at the Index, and then create Groups, for example Index (Column H) 1-500 would ALL display as Group 1 (or Group A), then Index 501-1000 would display as Group 2 (or Group B).  This process  would continue until all records had a group.  As there are 3,853 current records there would be 8 groups, however the final group would be less than the max of 500 records.  There are no corresponding groups that this count relates to, it is completely unrelated from everything else.  Thanks in advance!

 
Posted : 12/04/2023 12:14 pm
Riny van Eekelen
(@riny)
Posts: 1185
Member Moderator
 

Perhaps the easiest would be to use Table.Split and cut up the larger table into ones with 500 rows. This creates a list of tables, each 500 rows large and the last one contains whatever number of rows are left. Then convert the list to a table, add an index from one and expand. See the attached file for an example.

 
Posted : 13/04/2023 12:28 am
Share: