# Index Formula Question

#### msk7777

##### Active Member
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!
2006 Recruiter Contract Summary.xls
CDEFGHIJKLMNOPQRS
1620730199101698200200400373837111918551
17MikeKing
199580137815776440043
Sep 22-28th

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
...when two people tie for first place it isn't registering anything.

Can you elaborate?

actually, I just replicated it and made two people tie, it put one of them in first place and one of them in second place, I looks like it put the first person it comes too while going down the column as 1st place and the person after that second.

I noticed that the criteria for the highest number is >60, whereas the criteria for the second highest is >59. Is this correct?

Actually I noticed that too on this one tab, it was just a mistake and I already fixed that.

Replies
5
Views
302
Replies
1
Views
435
Replies
9
Views
484
Replies
3
Views
760
Replies
24
Views
1K

1,220,979
Messages
6,157,184
Members
451,403
Latest member
scorpidxls

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back