So this seems very basic, but I can't figure it out.

Here is a simple example:

John 12,000 1.2
Dan 9,000 1.1
Matt 8,100 1
Eric 5,500 0.75
Evan 7,300 0.89
Ron 11,100 1.25
Mike 6,400 1
Al 8,800 0 .9

Basically, I want to maximize column C while picking 6 people in column A, and so that column B sums to 50,000 (or less).

Anyone know how to do this?

Thanks

This post was edited by DoubleDouble on Aug 16 2016 06:55am