Welcome Guest
You last visited June 26, 2017, 2:52 am
All times shown are
Eastern Time (GMT-5:00)

# a MS Excel question

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

 Page 1 of 1
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:

 Type Date B1 B2 B3 B4 B5 1 4/19/2008 14 2 10 22 38 2 4/19/2008 6 40 19 34 28 3 4/19/2008 1 43 9 17 25 4 4/19/2008 7 32 36 9 17 5 4/19/2008 24 13 19 39 33 6 4/19/2008 21 48 11 10 49 1 4/23/2008 17 7 55 14 41 2 4/23/2008 17 37 35 21 7 3 4/23/2008 4 31 42 11 6 4 4/23/2008 30 28 5 45 44 5 4/23/2008 22 39 21 20 11 6 4/23/2008 17 39 40 5 34

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

 Type Date B1 B2 B3 B4 B5 1 4/19/2008 2 10 14 22 38 2 4/19/2008 6 19 28 34 40 3 4/19/2008 1 9 17 25 43 4 4/19/2008 7 9 17 32 36 5 4/19/2008 13 19 24 33 39 6 4/19/2008 10 11 21 48 49 1 4/23/2008 7 14 17 41 55 2 4/23/2008 7 17 21 35 37 3 4/23/2008 4 6 11 31 42 4 4/23/2008 5 28 30 44 45 5 4/23/2008 11 20 21 22 39 6 4/23/2008 5 17 34 39 40

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!

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

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!

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!