MS Excel, pasting tables into Lotterypost threads. https://www.lotterypost.com/thread/254159 Lottery Post Forum Topic: MS Excel, pasting tables into Lotterypost threads. en-us Lottery Post RSS Generator Reply #14 https://www.lotterypost.com/thread/254159/2866996 https://www.lotterypost.com/thread/254159/2866996 Sun, 06 Jan 2013 20:06:53 GMT LottoBoner =IF(DJ1489=2, 3O/2E ,0)+IF(DJ1489=3, 2O/3E ,0) '(?)

Sorry, not working.

Good try though serge.

]]> LottoBoner Reply #13 https://www.lotterypost.com/thread/254159/2866979 https://www.lotterypost.com/thread/254159/2866979 Sun, 06 Jan 2013 19:59:03 GMT LottoBoner I will test that in the cell and see if that helps.

Thanks.

]]> LottoBoner Reply #12 https://www.lotterypost.com/thread/254159/2866731 https://www.lotterypost.com/thread/254159/2866731 Sun, 06 Jan 2013 17:57:40 GMT SergeM =IF(DJ1488=2, 3O/2E ,0)+IF(DJ1488=3, 3O/1E ,0) '(?)

Can that not help

]]> SergeM Reply #11 https://www.lotterypost.com/thread/254159/2866335 https://www.lotterypost.com/thread/254159/2866335 Sun, 06 Jan 2013 12:42:40 GMT LottoBoner 1

15

1

10

3

a1

1

2

0

2

1

17

19

30

34

101

33

29

17

1

2

2

3

1

3

2

4

2

7

6

5

5

4

1

0

4

10

3

5

0

22

0

2

6

0

b1

0

0

3

2

22

23

26

33

34

138

12

11

11

0

3

2

0

3

2

3

2

5

2

8

7

7

4

2

0

]]> LottoBoner Reply #10 https://www.lotterypost.com/thread/254159/2866331 https://www.lotterypost.com/thread/254159/2866331 Sun, 06 Jan 2013 12:35:45 GMT LottoBoner Well I started with this and then I got stuck.

=IF(DJ1488=2, 3O/2E ,0

]]> LottoBoner Reply #9 https://www.lotterypost.com/thread/254159/2865477 https://www.lotterypost.com/thread/254159/2865477 Sat, 05 Jan 2013 21:30:48 GMT SergeM Maybe you should show your functions for 2O/3E instead.

]]> SergeM Reply #8 https://www.lotterypost.com/thread/254159/2865289 https://www.lotterypost.com/thread/254159/2865289 Sat, 05 Jan 2013 19:37:04 GMT LottoBoner Oh sorry!!! Forgot you dont like pink

]]> LottoBoner Reply #7 https://www.lotterypost.com/thread/254159/2865285 https://www.lotterypost.com/thread/254159/2865285 Sat, 05 Jan 2013 19:35:54 GMT LottoBoner If I copy paste directly into excel the following happens.

6 9 24 25 34 2 14 0 8 2O/3E

oh, nothing happened,

the webpage and excel happend to freeze for about a minute, but it seems the formatting remained.

That was not always the case from my prior experience.

]]> LottoBoner Reply #6 https://www.lotterypost.com/thread/254159/2832411 https://www.lotterypost.com/thread/254159/2832411 Sat, 15 Dec 2012 21:48:22 GMT JKING FILL IN RATE FOR 56 NUMBERS %

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

5 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0... [ More ]

]]> JKING Reply #5 https://www.lotterypost.com/thread/254159/2829143 https://www.lotterypost.com/thread/254159/2829143 Thu, 13 Dec 2012 19:17:42 GMT SergeM Like JADElottery showed, you can also copy the range and paste it in another program, then copy it again to paste it here.

With copy paste special you can paste as image. You might also paste to MS Paint.

]]> SergeM Reply #4 https://www.lotterypost.com/thread/254159/2829134 https://www.lotterypost.com/thread/254159/2829134 Thu, 13 Dec 2012 19:13:17 GMT CarliG Great Tip Serge

Thanks

Carlig

]]> CarliG Reply #3 https://www.lotterypost.com/thread/254159/2829129 https://www.lotterypost.com/thread/254159/2829129 Thu, 13 Dec 2012 19:11:32 GMT SergeM http://office.microsoft.com/en-us/excel-help/quick-start-apply-conditional-formatting-HA010370614.aspx

(For more detailed information about getting started with conditional formatting, see Add, change, find, or clear conditional formats. )

http://office.microsoft.com/en-us/excel-help/video-apply-conditional-formatting-VA101829631.aspx?CTT=3

]]> SergeM Reply #2 https://www.lotterypost.com/thread/254159/2828873 https://www.lotterypost.com/thread/254159/2828873 Thu, 13 Dec 2012 16:23:59 GMT JKING I failed the class. *L*

conditional format ...

Where is that in excel?

Is there a step by step for us dumbos

]]> JKING Reply #1 https://www.lotterypost.com/thread/254159/2822302 https://www.lotterypost.com/thread/254159/2822302 Sun, 09 Dec 2012 17:26:04 GMT JADELottery Direct paste and modification in LP.

Index Regression Wave 1 Wave 2 Wave 3 Wave 4 Wave 5 Wave 6 Wave 7 Wave 8 Wave 9 Wave 10 Wave 11 Wave 12 Remainder Data

1 2.313458539 0.384312956 0.17343884 0.097455385 0.064609119 -0.037528994 -0.001412214 0.00270631 0.001051589 0.000459051 0.000335274 0.000286892 0.000236965 0.000590287 3

2 2.314831525 0.384780175 0.172944347 0.095006646 0.070851513 -0.037237567 -0.009274671 -0.00188638 -0.001968518 -0.002023172 -0.00172318 -0.001316116 -0.0009... [ More ]

]]> JADELottery MS Excel, pasting tables into Lotterypost threads. https://www.lotterypost.com/thread/254159 https://www.lotterypost.com/thread/254159 Sun, 09 Dec 2012 17:00:32 GMT SergeM Select at range in Excel and paste it into the message box. You loose the layout/format.

1 2 3 4 5 6 7 8 9 10 11 12 right

6 8 9 10 12 13 14 16 17 19 21 24 9, 4, 5, 6

8 9 10 12 13 14 17 18 19 20 21 22 9, 6, 5, 5

4 5 8 9 10 12 13 14 15 17 19 21 7, 6, 7, 5

6 8 9 10 13 14 15 17 18 19 20 24 8, 4, 5, 7

5 8 9 10 13 14 15 16 17 18 21 24 8, 4, 5, 6

1 4 5 6 8 9 10 13 14 15 17 24 6, 5, 6, 6

5 6 8 9 10 12 13 15 16 17 18 19 9, 6, 7, 6

6 8 9 10 13 16 17 18 20 21 22

]]> SergeM