radar_jynx
New Member
- Joined
- Mar 16, 2009
- Messages
- 18
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
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