I am trying to find a function that will help me with a side project I am
working on. Simple Example: I have a list of ranked employees 1 - 10. In
A2:b12 A= Rank B = Employee Name. There is a bid/draft for these employees.
I am 5th in line to pick. I wanted to create a formula that would allow me
to decide what pick to make depending on what employees were eliminated on
picks 1 thru 4 AND who is ranked the highest in A2:B12. Is this possible to
do? If so how?