| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the first data point from a list of data
I am trying to make a Weekly data table from a Daily table for some financial
information, along the following lines: Date Open High Low Close 29/08/2008 558 565 545 550 28/08/2008 527 560 516 558 27/08/2008 525 525 505 519 26/08/2008 515 530 513 522 22/08/2008 522 535 514 530 21/08/2008 540 541 516 516 20/08/2008 560 560 530 540 19/08/2008 576 578 543 546 18/08/2008 610 614 587 587 15/08/2008 608 620 591 610 14/08/2008 581 606 572 602 13/08/2008 602 602 565 571 I want to pull the Open data for the first day in each week in the data series (ie 602 for 13/08/08, 610 for 18/8/08, 515 for 26/8/08, etc.). Does anybody know how I might go about doing this? Kind regards. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
| show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
| Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
| excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
| Including data in data table but not charting as a series or point | Charts and Charting in Excel | |||
Threaded Mode
