In one of my current workbooks I am using I have a formula =INDEX(C14:C49,MATCH(LARGE(IF(MOD(ROW(C14:C49)-ROW(C14)+1,3)=0,IF(K14:K49>60,K14:K49-ROW(K14:K49)/10^5)),1),K14:K49-ROW(K14:K49)/10^5,0)-2)
Basically this formula tells me who had the highest amount of contracts for a particular plan, but it has to be more than 60 contracts. The highest number is listed for 1st place. To indicate the second place winner I use this formula in a seperate cell =INDEX(C14:C49,MATCH(LARGE(IF(MOD(ROW(C14:C49)-ROW(C14)+1,3)=0,IF(K14:K49>59,K14:K49-ROW(K14:K49)/10^5)),2),K14:K49-ROW(K14:K49)/10^5,0)-2)
The issue I am running across is that when two people tie for first place it isn't registering anything. What I need it to do is when two people tie for first place it lists both names and leaves second place empty. I was hoping someone could help me with this. Thanks!
Basically this formula tells me who had the highest amount of contracts for a particular plan, but it has to be more than 60 contracts. The highest number is listed for 1st place. To indicate the second place winner I use this formula in a seperate cell =INDEX(C14:C49,MATCH(LARGE(IF(MOD(ROW(C14:C49)-ROW(C14)+1,3)=0,IF(K14:K49>59,K14:K49-ROW(K14:K49)/10^5)),2),K14:K49-ROW(K14:K49)/10^5,0)-2)
The issue I am running across is that when two people tie for first place it isn't registering anything. What I need it to do is when two people tie for first place it lists both names and leaves second place empty. I was hoping someone could help me with this. Thanks!
2006 Recruiter Contract Summary.xls | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
14 | HillaryAdams | ||||||||||||||||||
15 | TotalContracts | NewProv. | DPMContr. | HardStates | AddPlan | AddLoc. | CPPO | CPPS | CPTotal | PO | PS | C5 | CF | DF | HP | HO | TotalPlans | ||
16 | 207 | 30 | 199 | 10 | 169 | 8 | 200 | 200 | 400 | 37 | 38 | 37 | 1 | 1 | 19 | 18 | 551 | ||
17 | MikeKing | ||||||||||||||||||
18 | TotalContracts | NewProv. | DPMContr. | HardStates | AddPlan | AddLoc. | CPPO | CPPS | CPTotal | PO | PS | C5 | CF | DF | HP | HO | TotalPlans | ||
19 | 9 | 5 | 8 | 0 | 1 | 3 | 7 | 8 | 15 | 7 | 7 | 6 | 4 | 4 | 0 | 0 | 43 | ||
Sep 22-28th |