Mar 13 2022 12:23 AM
Mar 13 2022 04:58 AM
@katieE1885 Can you give an example of what you mean by "split into groups of £50k" ?
Mar 13 2022 05:09 AM
Mar 13 2022 05:32 AM - edited Mar 13 2022 06:58 AM
@katieE1885 If you can live with batches that may not exceed 50000, than perhaps the attached workbook may help. I created a list of 200 random amounts. Using the MOD function to determine when the running total exceeds 50000 and an IF to assign a batch number.
Mar 13 2022 06:29 AM
Mar 13 2022 07:00 AM
@katieE1885 Ooops! don't think so as I believe I made a mistake.
Mar 13 2022 07:11 AM
Mar 13 2022 07:16 AM - edited Mar 13 2022 07:18 AM
@katieE1885 No it does not. Only the first batch is correct. Some others may be correct but that's a coincidence. Just sum the amounts per batch and you will see that some go over 50000. Sorry about that!
Mar 13 2022 07:59 AM
@katieE1885 I'll see if I can come up with something better. Or perhaps someone else!