Calling all Excel Gods

[WrathOfAchilles]

Hi,

I have 84 rows (Say Car Garages) and 300 Columns (Other garages) and the values are the distances to given garages. So for row 1, there are 300 different distance values to other garages.

I have a MIN(XX:EE) to give me the closest garage in say column 302. Now, that i want in column 303 is the 2nd closest garage and in column 304 the 3rd closest garage! Affectivle MIN+1 and MIN+2 but this doesn't exist. I can't do if statement saying not value MIN(XX:XX) as 1 of the values in the range will meet it and it will error out.

Any ideas? I dont want to haven to hack data and put into SQL!

Ta,
Marty

 

[kinneh]

=large(xx:ee,2)
=small(xx:ee,2)

Where '2' is your 2nd, 3rd smallest. That might work.

 

[kkelly]

http://www.techonthenet.com/excel/formulas/small.php

=Small will defo do what you require.

 

[WrathOfAchilles]

Ace, cheers.

Marty