Divide list into 2 equal parts based on sales

Hi, I have a list of accounts and their sales, I need to divide the list into 2 separate lists with similar revenue totals, and #accounts as possible. What is the best way to achieve this?

Please provide some sample input data and desired output. Your query isn’t specific enough for anyone to help yet :slight_smile:

Absolutely see below. So the # of accounts in each list is similar, and the distribution of revenue in each list is close as well
2022-10-28 12_20_55-Book1 - Excel

@ahortonmilsig sort and create a Counter and then split by every odd number (Chapter 7 / Exercise 1 – KNIME Hub)?

1 Like