ddalexander1
New Member
- Joined
- Dec 20, 2009
- Messages
- 8
I'm fairly good with Excel, but this one has me stumped.
I have two spreadsheets with data for records which are found in in column A. There is not necessarily a record in sheet2 for every record in sheet1. The columns of the two sheets represent dates and those columns and dates are the same in the two sheets. Dates are found in the header row.
In a third sheet, I need every record from Sheet1. Where there is a record in sheet2, I need the sum of data in sheet1 and sheet2 for each date for each record so that for each record in Sheet1 I can identify the minimum date (found in header row of sheet1 and/or sheet2) for which the running total (both sheets) for each record is first equal to or greater than 190,000.
I can think of lots of functions, index, max, sutotal, vlookup, but I just can't figure out how to put them all together to get the one date for each record. Has anyone solved this problem before? THANKS!
I have two spreadsheets with data for records which are found in in column A. There is not necessarily a record in sheet2 for every record in sheet1. The columns of the two sheets represent dates and those columns and dates are the same in the two sheets. Dates are found in the header row.
In a third sheet, I need every record from Sheet1. Where there is a record in sheet2, I need the sum of data in sheet1 and sheet2 for each date for each record so that for each record in Sheet1 I can identify the minimum date (found in header row of sheet1 and/or sheet2) for which the running total (both sheets) for each record is first equal to or greater than 190,000.
I can think of lots of functions, index, max, sutotal, vlookup, but I just can't figure out how to put them all together to get the one date for each record. Has anyone solved this problem before? THANKS!
