Excel Help Please...

Reply #16

LottoChica23 — Sun, 16 Jul 2006 19:08:41 GMT

Thanks for the info Karnac.

I really like the first link, it's loaded with very good examples; and it talks too

Reply #15

lottaloot — Sun, 16 Jul 2006 15:47:56 GMT

Thanks for that information, Karnac

Reply #14

Karnac — Sun, 16 Jul 2006 13:02:25 GMT

Here are a couple of websites that I have found useful for excel ...the second of which deals with lottery information....and turn up your speakers for the 1st one.

http://www.datapigtechnologies.com/ExcelMain.htm

http://www.mrexcel.com/tip092.shtml

Reply #13

Raven62 — Sun, 16 Jul 2006 12:51:54 GMT

LOL! Lotus 123 is alive and well

Reply #12

LottoChica23 — Sun, 16 Jul 2006 12:35:56 GMT

You're welcome. I know what you mean, I had that problem one day too and I knew there had to be a way to fix it. Pogo is correct in saying that you may run into problems performing arithmetic computations on cells formatted as text. You will get unpredictable results.

Good luck with your worksheet and many hits to you.

Reply #11

LottoChica23 — Sun, 16 Jul 2006 12:28:38 GMT

You're welcome Pogo, you learn something new every day. I'm still learning a few excel tricks here and there.

I remember back in the day when Excel used to be called Lotus 123, my has it grown up! (That may be before some folk's time...

Reply #10

Pogo — Sat, 15 Jul 2006 03:15:08 GMT

Bryan, it would be a good idea to reformat your numbers like LottoChica is saying, because having them in a text format will prevent them from showing up correctly when you decide to use formulas and the such. But if your not having problems with them formatted as text - Rock On!

Thanks for the tip on the leading 0 LottoChica - always bugged me that I didn't have a perfectly lined up columns of numbers...

Later, Pogo

Reply #9

Bryan — Sat, 15 Jul 2006 01:15:39 GMT

Thanks LC23,

I was wondering about that. I got to show up with formatting the cell to text. I didn't know if that would have any adverse effect or not. But the 0 stayed when I did that and that is all I was after...

Thanks to everyone for all the ideas and formulas.

It is very helpful,

Bryan

Reply #8

LottoChica23 — Sat, 15 Jul 2006 00:57:14 GMT

You're welcome fibonacci. In addition, when you have a number such as 095 and the leading zero does not appear in the cell, you can fix this by using a custom format (Format--> Cells--> Custom) of 000 to fix that problem. After doing this, all of your leading zeroes will show up.

Reply #7

rock50 — Thu, 13 Jul 2006 16:22:12 GMT

How can you write an Excel formulas, that will calculate what numbers are coming more frequently than others in this sheet, with/out counting each column yourself? Would possibly make choosing your 3 numbers to play easier.

Reply #6

Fibonacci — Thu, 13 Jul 2006 11:46:52 GMT

Lottachiaca and Lottalott thanks for these Excel tips. Great info. I use Excel a lot (every day) but I have learned more on LP than the books i read and courses I took.

Reply #5

mchpick3! — Thu, 13 Jul 2006 03:33:43 GMT

Bryan, can you send me when you are finished those two numbers came out in Va 639 then the next night 128 came out this tool would be very helpful. I need lessons on excel also my computer has Quattro Pro and I really don't know how to set up anything.

Thanks

Reply #4

Pogo — Tue, 11 Jul 2006 03:31:55 GMT

Here's your answer buddy... I hope it helps you in your quest:

Number100's10's1's0123456789

7/3/2006320321011000000

7/4/20069369360001001001

7/5/2006100102100000000

7/6/20068218210110000010

7/7/2006490491000100001

LottoChica23 already showed you how to break the numbers down individually, so here's your equation you need. I made it for F2 then copied pasted it into the rest of the cells as needed.

=(COUNTIF($C2,F$1)+COUNTIF($D2,F$1)+COUNTIF($E2,F... [ More ]

Reply #3

lottaloot — Tue, 11 Jul 2006 02:42:35 GMT

This is for those that do not know how to change this draw result into box form:

In columns B:D, I have the draw result. ex: 3|3|5

Wherever you want the actual result (335) to end up is where you place this formula

=CONCATENATE(B2,C2,D2)

Then wherever you want the box form to end up is where you place this formula.

=CONCATENATE(SMALL(B2:D2,1),SMALL(B2:D2,2),SMALL(B2:D2,3

Reply #2

Bryan — Tue, 11 Jul 2006 00:13:43 GMT

Thank you for the info. I am printing this out for further reference. But Winsumloosesum has already fixed it for me.

Thanks again. It is so nice to know that help is available around every corner.

Best of Luck,

Bryan

Reply #1

LottoChica23 — Tue, 11 Jul 2006 00:05:01 GMT

OK Bryan,

I do know that this has to be done in a few parts. First you have to break the digit number into 3 separate digits, meaning that 032 would become 0 3 2. This would take up 3 additional columns. Assuming that we are using the number in the second column (B) to do this and you are and putting the formula in column C the formula would look like this: =INT($B3/100) In column D the formula would look like this =INT(($B3-(C3*100))/10) In column E the formula would look like this

Excel Help Please...

Bryan — Mon, 10 Jul 2006 23:01:33 GMT

Howdy All,

Let me start by saying that I am completely lost when it comes to Excel but I am trying to learn. Any help is appreciated...

O.K. I have 2 questions. Here is what I am working on...

DateNumbersBox0123456789

7/3/060320231 11

7/4/06936369 1 1 1

7/5/0601000121

7/6/06821128 11 1

7/7/060490491 1 1

7/8/06672267 1 11

7/9/06499499 1 2

I need the formulas that can do this for me. When I put (032) in the