Need some Excel Help...

Reply #19

sysp34 — Sat, 26 Apr 2008 01:46:00 GMT

Rakster

why not use mid function and give month reference for example this formula

Jan 01

Thu, Apr 24, 2008 2-6-7 =INDEX($B$1:$B$12,MATCH(MID(D1,6,3),$A$1:$A$12,0)) / MID(D1,10,2) / MID(D1,14,4)

Feb 02

Wed, Apr 23, 2008 4-8-3 =INDEX($B$1:$B$12,MATCH(MID(D2,6,3),$A$1:$A$12,0)) / MID(D2,10,2) / MID(D2,14,4)

Mar 03

Tue, Apr 22, 2008 9-2-4 =INDEX($B$1:$B$12,MATCH(MID(D3,6,3),$A$1:$A$12,0)) / MID(D3,10,2) / MID(D3,14,4)

Apr 04

Mon, Apr 21, 2008 8-0-9 =INDEX($B$1... [ More ]

Reply #18

Rakster — Fri, 25 Apr 2008 17:45:38 GMT

Thanks Buddy

Reply #17

Texas MadMan — Fri, 25 Apr 2008 17:39:06 GMT

In step 6 above, instead of selecting Delimited , select Fixed Width ..............it's sort of a pain, but once you get used to importing data into excel this way, I think you will find it's very flexible and useful.

Reply #16

Rakster — Fri, 25 Apr 2008 17:23:56 GMT

I think its got something to do with the dashes in between the numbers... like 6-7-8 instead of just having 678.

Once I deleted these dashes all is ok.. .so I might as well do it manually as I wasted a lot of time with this stupid program and I am no further ahead...lol

I appreciate everyones input and help.. .thank you all so much.

Reply #15

Rakster — Fri, 25 Apr 2008 17:15:33 GMT

I appreciate all the help, but where do you find this fixed width

Reply #14

Texas MadMan — Fri, 25 Apr 2008 17:11:17 GMT

Rakster, another option, which will work better for the way LP formats the dates is to select fixed width instead of delimited and then you can create a break between the date and the pick 3 results so that your data imports into two columns like you want. I hope this helps.

Reply #13

Texas MadMan — Fri, 25 Apr 2008 16:52:14 GMT

Ah, okay, Rakster. I will explain the way I get data into excel. It's a little bit more complicated, but it works great.

1. Create a new blank text document and name it pick3results or whatever you want.

2. Paste the data from LP into the text document and save it.

3. Open up a new excel file.

4. Select the Data tab, Import External Data... , Import Data...

5. Locate the text file you created and select open.

6. Click the Delimited circle and then next

7. Check the space b... [ More ]

Reply #12

Rakster — Fri, 25 Apr 2008 16:51:39 GMT

I thought that would work but it turns all pk 3 numbers to a date except the odd number when I copy it from the wordpad to the spreadsheet.. same thing happenes...dates... wt

Reply #11

CARBOB — Fri, 25 Apr 2008 16:45:16 GMT

Try saving in Notepad, then in Excel, import Text.

Reply #10

Rakster — Fri, 25 Apr 2008 16:38:18 GMT

Heres what it looks like on a fresh worksheet... on regular paste.

Thu, Apr 24, 2008 2/6/2007

Wed, Apr 23, 2008 4/8/2003

Tue, Apr 22, 2008 9/2/2004

Mon, Apr 21, 2008 8-0-9

809 appears but the rest show a date???

This is what it looks like if I use special paste and unicode...

Thu, Apr 24, 2008 2-6-7

Wed, Apr 23, 2008 4-8-3

Tue, Apr 22, 2008 9-2-4

Mon, Apr 21, 2008 8-0-9

Sat, Apr 19, 2008 3-4-0

Fri, Apr 18, 2008 2-6-6

Reply #9

Rakster — Fri, 25 Apr 2008 16:28:40 GMT

I am copying numbers from here on LP..

Illinois Midday pick 3.

I copy them and go to the spreadsheet but all I get is a mess and do not want the hassle of deleteing the date for every number that I pasted.. too time consuming.. .thought for sure that there was a way to do this without the hassle.

Reply #8

Texas MadMan — Fri, 25 Apr 2008 16:25:44 GMT

Sorry, Rakster, but you kind of lost me there. I'm not sure what's going on with your spreadsheet. I use the same format for mine - the first column is the dates and the second column is the actual draws.

If you copy multiple cells, then you should be able to paste all of them by just selecting the top of the range where you want them to be pasted and then paste special or paste . I guess I would understand the problem better if I knew what you were copying the data from.

Reply #7

Rakster — Fri, 25 Apr 2008 16:20:29 GMT

There are 2 columns... one is the actual date, the other one is the number. When I paste special it combines both into one cell... is that correct? Can it be posted to 2 different cells if both cells are highlighted when pasted? I have to use special paste and then unicode text

Thanks for all your help.

Reply #6

Texas MadMan — Fri, 25 Apr 2008 15:35:03 GMT

Right click the cell where you want to paste the results and then try Paste Special... instead of Paste . When the Paste Special Box appears, select the values box. See what that does.

Reply #5

Rakster — Fri, 25 Apr 2008 15:31:37 GMT

I did this, and i stil lget a date format.

Reply #4

Texas MadMan — Fri, 25 Apr 2008 15:30:24 GMT

After you change the format of the cells you will have to repaste your pick 3 results.

Reply #3

Rakster — Fri, 25 Apr 2008 15:23:23 GMT

Nope... tried this... right click then clicked on number and stil lthe same.

tried it again and clicked on general and stil lthe same.

Reply #2

MillionsWanted — Fri, 25 Apr 2008 15:13:33 GMT

You need to format the cells to NUMBER. Chose which cells you want to format and right click. Chose Format Cells and pick Category: General from the Number tab. Click OK.

Reply #1

Texas MadMan — Fri, 25 Apr 2008 15:12:06 GMT

Select the cells in the second column and then right click on the selection. Choose Format Cells... and then change the format from Date to General . That should do it

Need some Excel Help...

Rakster — Fri, 25 Apr 2008 15:03:04 GMT

How does one change this...

I cut and paste past numbers into a column yet it gives me a date instead of the number.

Like this below..

Thu, Apr 24, 2008 2/6/2007

Wed, Apr 23, 2008 4/8/2003

How do I change this to get my pick 3 number in the 2nd column?

Thanks