##### New Member
Using

D3 =INDEX(B6:BK45,MATCH(SMALL(I6:I45,COUNTIF(I6:I45,0)+1),I6:I45,0))

Using that i can link the smallest number in a Range To a Text Value in another range Eg.
I6= 2 B6 = Ben
I7= 4 B7 = Bob
I8= 1 B8 = Bill

Therefore D3 = Bill becasuse I8 is the smallest value

However i want the the equation so that every second cell is counted to fin the smallest value and = 2 Names eg.
I6 = 2 B6 = Ben B7 = Bob

I8= 4 B8=Jill B9=Jane

I9= 1 B10=Rob B11=Rhett

Therefore D3 = Rob & Rhett

any help would be much appreciated thanks

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
What if you combine the names in a convenient range of cells using an appropriate formula (=B8 & " & " & B9 perhaps) and then use your formula in D3 to reference this range instead.

Replies
4
Views
773
Replies
3
Views
363
Replies
4
Views
277
Replies
2
Views
1K
Replies
3
Views
780

1,196,288
Messages
6,014,495
Members
441,823
Latest member
GregG26

### 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