Formula for determining next occurrence in a list

Hello... I've been working for a week on a spreadsheet and have had great trouble building the right formula. I've done a lot of Google searching and I keep getting this forum as a result to many of the questions. So, I figured I'd post the problem here.

I am building a spreadsheet that will determine the closest fire apparatus to a location. I have the columns labelled Station, Time, Distance, Apparatus. I have already determined the distance and time the apparatus is from a station. However, we have over 60 fire stations. I would like for the spreadsheet to first search down the list of time for the minimum time. There are several occurrences of stations having the same time. So, as a second criteria, I'd like it to look at the distance for the minimum distance. Finally, I'd like to look and see if that station has apparatus available. I'd like the list to return the first, second, and third closest engines and ladders to a location. Not every station has both an engine and ladder. I've used an "x" to denote whether a station has an engine and ladder, or not.

Here is an example:

A1= Station, B1=Time, C1=Distance, D1=Engine, E1=Ladder
A2=1, B2=4, C2=3.2, D2=x, E2=<blank>
A3=2, B3=1, C3=0.4, D3=x, E3=x
A4=3, B4=4, C4=3.5, D4=x, E4=x
A5=4, B5=8, C5=5.5, D5=x, E5=<blank>

Is it possible for a formula to return: the closest and 2nd closest engine, the closest ladder and 2nd closest ladder? All it would need to do is return the number in column A. I'd appreciate any help or suggestions you may have. Thanks!