Folks,
I am trying to figure how to best get the data I need given multiple changes
in a year. For example, cost for a product may go through several updates
throughout the year. So, to ensure that I get the most up-to-date costng
during that year..I download the Jan 1 to Dec 31st range of data by our
products. Now the problem is one product may have had 4 revisions during the
year with the last one coming in, say, October. This is how my data is
coming up:

Product# Costing Date
65899 01/01/2007
65899 03/01/2007
65899 09/01/2007
65569 03/01/2007
65569 10/01/2007

Using the above as an example, how can I ensure that I get the latest update
per product. So, Prod # 65899 comes back with 09/01/2007 and 65569 comes back
with 10/01/2007

I tried to do a pivot putting the Prod #s in Rows, the costing Dates (i.e.
12 months) in Columns and ofcourse the costs under Data. By doing this I got
a view of any SKU by all 12 months. So, 65569 will populate March and
October and leave the other cells blank. I thought I would be able to manage
what I need by first putting it in a Pivot format. But I don't how to
proceed any further.

Hoping to get some tips on this file. Thank you very much.