Job Distribution

[Aloun]

Hi Everyone,

I'm trying to create a macro for my attached spreadsheet.

We want to distribute an "exclusive" to the person starting with the highest gross income.

So I want to be able to enter a unit in the unit column and run a macro that will pop a name in the agent column according to the table on the left.

I want to be able to do this "round robin" style where we we go down the list of those qualified for one until we have no more units to give out.

Happy to take any suggestions/any help!

Thank you!

 

[SirJB7]

Hi, Aloun!

Welcome to Chandoo forums!
Checked this yet?
http://chandoo.org/forum/forums/new-users-please-start-here.14/

About your question, why not using formulas?
=SI.ERROR(INDICE(A$2:A$32;COINCIDIR(K.ESIMO.MAYOR(SI(D$2:D$32="Y";C$2:C$32);FILA()-1);C$2:C$32;0));"") -----> in English:
=IFERROR(INDEX(A$2:A$32,MATCH(LARGE(IF(D$2:D$32="Y",C$2:C$32),ROW()-1),C$2:C$32,0)),"")

It's an array formula so enter it with Shift+Ctrl+Enter instead of just Enter.

Regards!