Forum Discussion
Solving 'The Assignment Problem' with Lambda
In attached file PQ Assignment2 generates the required rows only
Though, it's slower than djclements initial approach (PQ Assignment1)
Patrick2788 Nice solutions presented by everyone! Here's a Power Query option to add to the mix (see attached workbook). I am by no means a PQ expert... I just knew the logic/steps I wanted to follow and muddled my way through the editor until I found what I needed. Basically, I used table joins (many-to-many) to generate all possible permutations, then added custom columns to filter by unique workers and total cost. Enjoy!
This PQ solution is very clean and works well with the larger personnel matrix, too! It's amazing how many options are available to solve this problem in Excel 365 in 2023 vs 2018, for example. Lambda, PQ, Solver, etc. - take your pick.