Wednesday, March 19, 2008

Run a web query and get lottery results for analysis

Three easy steps to get web data into your Excel Spread Sheet. This shows how you may get megamillion lottery results for later analysis (speculation?).

Step 1:
Open the web query window using Microsoft Excel as shown.



Step 2:Enter the following (or cut and paste) URL
http://www.megamillions.com/winningpicks/last_25.asp into the address box


Step 3:
Accept Excel's default location for pasting the data



La voila!, the results (only part of it shown here) are in your spread sheet now.

No comments:

DMCA.com Protection Status