Productivity Ranking

**hunter_jack** · 12-18-2010, 12:28 PM

Can anyone please help me with my template in identifying the top performer in my group using two criteria. Here's the scenario I want to imply with my template. If I choose Veterans as type of member (criteria1) then uses 2 as top number (criteria2), the value in the result should show the Overall Completed of the Veterans in the Top 2 position.

I have attached a file that you can use as to what I am thinking

Hope to hear reply from anyone who can assist me.

Thanks in Advance!

**scottylad2** · 12-18-2010, 12:34 PM

you have
Veterans 100
Veterans 200
Veterans 300
Veterans 400

so how to you arrive at 300 for the following statement?

result should show the Overall completed of the Top 2 veteran which is 300

**scottylad2** · 12-18-2010, 01:38 PM

Ok, you've not answered my last query so I've made an attempt based on what I think you want. It's an array formula so needs to be entered with ctrl+shift+Enter hope it's right Oh and by the way, i've put your answer on sheet 2, ignore what is on sheet one as thats a response to a different query by someone else and can't be bothered making another sample sheet

**hunter_jack** · 12-18-2010, 04:05 PM

For your first reply. If the only Type I have are all Veterans, I would use the the LARGE function and using the first mentioned column as my array and number 2 as my K.

For the 2nd reply. I think what you did on your sample is the one I am trying to do for 3 days now.

Thank you very much scottylad2.

**scottylad2** · 12-18-2010, 04:25 PM

Glad to help

**hunter_jack** · 12-18-2010, 05:02 PM

Ah... May I ask, what is the function of enclosing the formula "{}" I am seeing in the formula you provided? Also, when I try to place your formula to other cells, the result returns a #VALUE!. As I've check the Calculation steps, it shows that the formula for the "LARGE(IF(A2:A8=D2" are resulting to the mentioned error. I really want to understand the formula you used. Please advise.