Welcome Guest
Log In | Register )
You last visited December 4, 2016, 7:21 pm
All times shown are
Eastern Time (GMT-5:00)

a MS Excel question

Topic closed. 3 replies. Last post 8 years ago by Texas MadMan.

Page 1 of 1
PrintE-mailLink
ArtVandalay's avatar - 3237774708 dd3351ee2c_m.jpg
Arizona
United States
Member #52803
June 10, 2007
88 Posts
Offline
Posted: August 6, 2008, 10:53 pm - IP Logged

I have a MS Excel question.  If you have a series of 5 number draws that look like this:

 

TypeDateB1B2B3B4B5
14/19/2008142102238
24/19/2008640193428
34/19/200814391725
44/19/200873236917
54/19/20082413193933
64/19/20082148111049
14/23/2008177551441
24/23/2008173735217
34/23/200843142116
44/23/2008302854544
54/23/20082239212011
64/23/2008173940534

 

Using MS Excel functions, how can you get the following results:

 

TypeDateB1B2B3B4B5
14/19/2008210142238
24/19/2008619283440
34/19/200819172543
44/19/200879173236
54/19/20081319243339
64/19/20081011214849
14/23/2008714174155
24/23/2008717213537
34/23/200846113142
44/23/2008528304445
54/23/20081120212239
64/23/2008517343940

 

Using the MAX and MIN functions can get B1 and B5, but how can you get B2, B3, and B4 in the right order?

Money can't buy you happiness, but I sure could afford the misery that it brings! Wink

    Avatar
    New Mexico
    United States
    Member #58526
    February 18, 2008
    683 Posts
    Offline
    Posted: August 6, 2008, 10:58 pm - IP Logged

    use the SMALL or LARGE function

    for example =SMALL(A1:A5,1)   that will return the smallest value from range A1 through A5

                       =SMALL(A1:A5,2)  that will return the 2nd smallest value from range A1 through A5

      ArtVandalay's avatar - 3237774708 dd3351ee2c_m.jpg
      Arizona
      United States
      Member #52803
      June 10, 2007
      88 Posts
      Offline
      Posted: August 6, 2008, 11:12 pm - IP Logged

      Thanks Texas MadMan, that works perfectly!

      Money can't buy you happiness, but I sure could afford the misery that it brings! Wink

        Avatar
        New Mexico
        United States
        Member #58526
        February 18, 2008
        683 Posts
        Offline
        Posted: August 6, 2008, 11:14 pm - IP Logged

        Thanks Texas MadMan, that works perfectly!

        No problem, glad to help.