Hi Experts, this one has got me stumped. The attached sample workbook should explain what I'd like.
In short, I want to create a pseduo-solver type equation for a resource allocation problem. Ala, I want the the largest values in range G:AA to determine what Aircraft Type the Flight Hours value in column F should go to. A method to mitigate ties in Range G:AA is explained in the workbook.
Hoping you can help me save a lot of time here.