Finding lowest three values

[wayne0881]

Hi All,

I am looking to find and return some values.


in cells B4,B6,B8,B10,B12,B14 I have values 1,2,3,4,5,6 representing greyhound traps

in cells Q4,Q6,Q8,Q10,Q12,Q14 I have race times

What I would like to do in cells D,E,F 17 is to sort the times into the three lowest and return the values in the B cells

For example if the lowest three times were 31.00 (3),31.31(5),31.34(2)

I would like in D17=3 E17=5 F17=2

Thanks in advance

 

[etaf]

try
=INDEX($B$4:$B$14,MATCH(SMALL($Q$4:$Q$14,1),$Q$4:$Q$14,0))
for the smallest d17
=INDEX($B$4:$B$14,MATCH(SMALL($Q$4:$Q$14,2),$Q$4:$Q$14,0))
e17
=INDEX($B$4:$B$14,MATCH(SMALL($Q$4:$Q$14,3),$Q$4:$Q$14,0))
f17

 

[wayne0881]

try
=INDEX($B$4:$B$14,MATCH(SMALL($Q$4:$Q$14,1),$Q$4:$Q$14,0))
for the smallest d17
=INDEX($B$4:$B$14,MATCH(SMALL($Q$4:$Q$14,2),$Q$4:$Q$14,0))
e17
=INDEX($B$4:$B$14,MATCH(SMALL($Q$4:$Q$14,3),$Q$4:$Q$14,0))
f17

Works a treat! nice one

Thanks

 

[etaf]

you are welcome