I have a large table of weekly equity data coming out of another program from which I need to collect a compacted table of the week by week results. The table is currently about 10 years of data with (typically) 5-10 lines/week. The input data to calc looks like the following data, somewhat simplified for the sake of this email:
Year Week Equity 2004 2 374 2004 2 -52 2004 3 154 2004 4 774 2004 5 -426 2004 6 774 2004 6 618 2004 6 622 2004 6 1396 2004 7 644 2004 7 218 2004 9 354 2004 9 178 2004 10 454 2004 10 28 The resulting table I want to get in calc should look like this: 2004 2 -52 2004 3 154 2004 4 774 2004 5 -426 2004 6 1396 2004 7 218 2004 8 0 2004 9 178 2004 10 28 The final table consists of the last line of a given week number. Note that if a week is missing I need to fill that in with a 0 value. I wonder if someone knows of way to do this. It's not hard to find the right data, just looking for when the week number changes, but I don't know how I might compact the table. Any ideas appreciated. Thanks, Mark --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org