I have a spreadsheet that lists data from certain wells on the date they were
taken. The date and data are listed down two separate columns. In another
worksheet, I need to retrieve and compare the data from the current month to
data from that same well 3, 6, and 12 months ago, is there anyway to have
Excel do this?
eg (comma separates columns):
From:
Date, Measurement
2/1/2007, 3000

I need:
1 year ago, Measurement
2/1/2006, 3003