Spreadsheet: 111630d1307983672-following-the-latest-entry-and-the-past-2-entries-workbook42
Sheet: DAILY NUMBERS

DATE | GAME | NUMBER | B1 | B2 | B3 | R |  | ODD/EVEN COUNT |  |  |  |  | LAST 20 DRAWINGS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUMS
2011-05-07 00:00:00 | [NAME] | 755
 | EVENING | 98
2011-05-08 00:00:00 | [NAME] | 993
 | EVENING | 295 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | EVENING
2011-05-09 00:00:00 | [NAME] | 506
 | EVENING | 044
2011-05-10 00:00:00 | [NAME] | 476
 | EVENING | 598
2011-05-11 00:00:00 | [NAME] | 784
 | EVENING | 913
2011-05-12 00:00:00 | [NAME] | 173
 | EVENING | 508
2011-05-13 00:00:00 | [NAME] | 862
 | EVENING | 201
2011-05-14 00:00:00 | [NAME] | 186
 | EVENING | 016
2011-05-15 00:00:00 | [NAME] | 576 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In columns [NAME] I just picking up the lastest two entries.  In columns Y1-AE5 I'm trying to automatically "pick-up" the last three digit entry and past two game first ball number  under it's specific "game" title (i.e.: Midday or Evening).  The time of the drawing will update with every new drawing - EVENING or [NAME].  Is there some coding I could use which will allow me to do this? Or is there a better way to handle it?  As you'll notice in Columns M22 - S22 will update with every new game in an alternate matter and moving the past game up a row.
 | EVENING | 668
2011-05-16 00:00:00 | [NAME] | 017
 | EVENING | 944
2011-05-17 00:00:00 | [NAME] | 896
 | EVENING | 110 |  |  |  |  |  |  |  |  |  | LAST REPEAT DRAWN |  |  |  | LAST 20 EVEN/ODD ENTRIES
2011-05-18 00:00:00 | [NAME] | 989
 | EVENING | 331
2011-05-19 00:00:00 | [NAME] | 581
 | EVENING | 302
2011-05-20 00:00:00 | [NAME] | 013
 | EVENING | 009
2011-05-21 00:00:00 | [NAME] | 725
 | EVENING | 636
2011-05-22 00:00:00 | [NAME] | 089
 | EVENING | 927
2011-05-23 00:00:00 | [NAME] | 434
 | EVENING | 144
2011-05-24 00:00:00 | [NAME] | 047
 | EVENING | 660
2011-05-25 00:00:00 | [NAME] | 619
 | EVENING | 985
2011-05-26 00:00:00 | [NAME] | 714
 | EVENING | 733
2011-05-27 00:00:00 | [NAME] | 405
 | EVENING | 447
2011-05-28 00:00:00 | [NAME] | 776
 | EVENING | 52
2011-05-29 00:00:00 | [NAME] | 886
 | EVENING | 816
2011-05-30 00:00:00 | [NAME] | 748
 | EVENING | 481
2011-05-31 00:00:00 | [NAME] | 871
 | EVENING | 855
2011-06-01 00:00:00 | [NAME] | 338
 | EVENING | 859
2011-06-02 00:00:00 | [NAME] | 755
 | EVENING | 884
2011-06-03 00:00:00 | [NAME] | 487
 | EVENING | 569
2011-06-04 00:00:00 | [NAME] | 321
 | EVENING | 284
2011-06-05 00:00:00 | [NAME] | 357
 | EVENING | 699
2011-06-06 00:00:00 | [NAME] | 806
 | EVENING | 401
2011-06-07 00:00:00 | [NAME] | 892
 | EVENING | 642
2011-06-08 00:00:00 | [NAME] | 622
 | EVENING | 705
2011-06-09 00:00:00 | [NAME] | 125
 | EVENING | 663
2011-06-10 00:00:00 | [NAME] | 144
 | EVENING | 527
2011-06-11 00:00:00 | [NAME] | 596
2011-06-12 00:00:00
2011-06-13 00:00:00
2011-06-14 00:00:00
2011-06-15 00:00:00
2011-06-16 00:00:00
2011-06-17 00:00:00
2011-06-18 00:00:00
2011-06-19 00:00:00
2011-06-20 00:00:00
2011-06-21 00:00:00
2011-06-22 00:00:00
2011-06-23 00:00:00
2011-06-24 00:00:00
2011-06-25 00:00:00
2011-06-26 00:00:00
2011-06-27 00:00:00
2011-06-28 00:00:00
2011-06-29 00:00:00
2011-06-30 00:00:00
2011-07-01 00:00:00
2011-07-02 00:00:00
2011-07-03 00:00:00
2011-07-04 00:00:00
2011-07-05 00:00:00
2011-07-06 00:00:00
2011-07-07 00:00:00
2011-07-08 00:00:00
2011-07-09 00:00:00
2011-07-10 00:00:00
2011-07-11 00:00:00
2011-07-12 00:00:00