-
Senior Member
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules