| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve data for previous 3, 6, 12 month given current month
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Previous Month End | Excel Discussion (Misc queries) | |||
| Date of the First day of the previous month | Excel Discussion (Misc queries) | |||
| automatically update chart plotting current month and previous 6 | Charts and Charting in Excel | |||
| Calculate the first day of the month for the current month? | Excel Discussion (Misc queries) | |||
| get the latest day of the previous month | Excel Discussion (Misc queries) | |||
Threaded Mode
