How can I populate a table with hours based on 2 criteria?
Hi
I have a table of data which I need to parse based on 2 specified criteria and populate a graph table. The problem is that one field that is parsed is in a column and the other in a row, at the intersection is the data I want to sum. I have tried sumproduct, various array formula etc but cannot get it right.
You will see in the attached the first criteria is CstCtr and the other is the month end date, the graph sheet has CstCtr '3810' in field A49 and the month end dates are in row 45, the DataBaseFcst sheet has the data. I hope I have made my question clear, but I think if you check the attached it should be clear.
Thanks BaseForecast.xls
I have a table of data which I need to parse based on 2 specified criteria and populate a graph table. The problem is that one field that is parsed is in a column and the other in a row, at the intersection is the data I want to sum. I have tried sumproduct, various array formula etc but cannot get it right.
You will see in the attached the first criteria is CstCtr and the other is the month end date, the graph sheet has CstCtr '3810' in field A49 and the month end dates are in row 45, the DataBaseFcst sheet has the data. I hope I have made my question clear, but I think if you check the attached it should be clear.
Thanks BaseForecast.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER