Forum Discussion
Batching into monetary groups
Every month I need to split a huge batch of payments into groups of £50k - is there an easy way of doing this rather than having to manually figure it out ? Thanks
10 Replies
katieE1885 Can you give an example of what you mean by "split into groups of £50k" ?
- Thanks - so for example we have a list of say 200 suppliers all due to be paid different amounts say totalling £1million but we can only pay in three batches of £50000 a day. At present we are having to manually add /try and find random batches that add up to £50000. I’m hoping there is a formula or a macro or alike that I can apply to the listing of £1m which I’ll automatically split out into batches of £50000 saving hours of trying to add them up to make the £50k… hope that’s a bit clearer for you thanks
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.
