Results 1 to 4 of 4

Thread: New Excel Question

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 06-17-2011, 10:33 AM #1
    RandBlade
    RandBlade is offline
    Senior Member RandBlade's Avatar
    Join Date
    Jan 2010
    Posts
    19,465

    Default 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.
    Reply With Quote Reply With Quote
  2. 06-17-2011, 11:02 AM #2
    RandBlade
    RandBlade is offline
    Senior Member RandBlade's Avatar
    Join Date
    Jan 2010
    Posts
    19,465
    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.
    Reply With Quote Reply With Quote
  3. 06-17-2011, 05:55 PM #3
    Nessus
    Nessus is offline
    Nihilist Nessus's Avatar
    Join Date
    Jan 2010
    Posts
    7,318
    In the future, the Berlin wall will be a mile high, and made of steel. You too will be made to crawl, to lick children's blood from jackboots. There will be no creativity, only productivity. Instead of love there will be fear and distrust, instead of surrender there will be submission. Contact will be replaced with isolation, and joy with shame. Hope will cease to exist as a concept. The Earth will be covered with steel and concrete. There will be an electronic policeman in every head. Your children will be born in chains, live only to serve, and die in anguish and ignorance.
    The universe we observe has precisely the properties we should expect if there is, at bottom, no design, no purpose, no evil, no good, nothing but blind, pitiless indifference.
    Reply With Quote Reply With Quote
  4. 06-17-2011, 05:58 PM #4
    Kazuha Vinland
    Kazuha Vinland is offline
    Apprehendable Apprentice Kazuha Vinland's Avatar
    Join Date
    Jan 2010
    Posts
    617


    With Excel, it's like there's nothing that you can't do within mathematics. You just got to know how to do it.
    Tomorrow is like an empty canvas that extends endlessly, what should I sketch on it?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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