a MS Excel question https://www.lotterypost.com/thread/179415 Lottery Post Forum Topic: a MS Excel question en-us Lottery Post RSS Generator Reply #3 https://www.lotterypost.com/thread/179415/1094582 https://www.lotterypost.com/thread/179415/1094582 Thu, 07 Aug 2008 03:14:36 GMT Texas MadMan No problem, glad to help.

]]> Texas MadMan Reply #2 https://www.lotterypost.com/thread/179415/1094580 https://www.lotterypost.com/thread/179415/1094580 Thu, 07 Aug 2008 03:12:29 GMT ArtVandalay Thanks Texas MadMan, that works perfectly

]]> ArtVandalay Reply #1 https://www.lotterypost.com/thread/179415/1094569 https://www.lotterypost.com/thread/179415/1094569 Thu, 07 Aug 2008 02:58:15 GMT Texas MadMan 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

]]> Texas MadMan a MS Excel question https://www.lotterypost.com/thread/179415 https://www.lotterypost.com/thread/179415 Thu, 07 Aug 2008 02:53:12 GMT ArtVandalay 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

]]> ArtVandalay