New Excel Question

This one is for an MMO online game I'm playing oddly enough. I need to time the attacks from different cities to the target to arrive at the same time. For that purpose I've got a column A with the time that it takes to reach the destination. I've got a cell with the time I want the attacks to arrive, so then column I2:I13 (currently but will increase, I can adjust that) lists the times that the attacks need to depart in order to all hit at that time.

But depending upon the target, these are in a completely messed up order. I would like to be able to use a formula to be able to re-arrange these in another column from first to last.

So there's an unsorted array I2:I13 and I imagine I need to be able to find out what the lowest, second-lowest and so forth value of that array is. I'm sure I've done this before, but can't think how.

Figured it out myself using a function I've never heard of before.

A column =small(array,position) to get lowest value up to highest
Then column next to it =match(outcome of last one,array,0) to find out where that one came from.

Never heard of the small or large functions before.

http://img.photobucket.com/albums/v3...tian/Kirby.jpg

:haha:

With Excel, it's like there's nothing that you can't do within mathematics. You just got to know how to do it.