![]() ![]() The following is an array formula, that spills the entire result and considers more than one target key, even in the example there is only one value. ![]() Please, note that I want a constant value, so I am not expecting to use ctrl+shift+enter.Īssuming no Excel version constraints as per the tags listed in the question. In this formula I have the "1" of the fact_table on G27 cell (hence offset(G27 25-row() 0) gives me "AP01100" while offset(G27 26-row() 0)) gives me "GENNAIO") the wrong way) but I really hope there is something smarter: I started writing the following formula (only for the first person to recruit on january and it's missing a vlookup for gg_Target, anyway I think it's clear the way I am thinking about it. The meaning is: I want to recruit 1 person from january to december and 4 people from february to december (that's why the "4" from fact table ignores january information) (0 * mar_cost * mar_days + 0 * apr_cost * apr_days +. (4 * feb_cost * feb_days + 4 * mar_cost * mar_days +. (1 * jan_cost * jan_days + 1 * feb_cost * feb_days +. I need to do this formula for each row of the fact table (to be added next to "DICEMBRE"): ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |