Excel support with GROWTH formula
Hi,
I am attempting to regress some data with the GROWTH formula but I cannot seem to get this to work. I’m hoping someone on this forum may have an idea as to why the below formula is not working. TIA for your help!
“=GROWTH(FILTER(Actual_Base_25,(Actual_Country=Regressed_Country)*(Actual_Refinement=Regressed_Refinement)),FILTER(Actual_Grade,(Actual_Country=Regressed_Country)*(Actual_Refinement=Regressed_Refinement)),Regressed_Grade)”
Hi, I am attempting to regress some data with the GROWTH formula but I cannot seem to get this to work. I’m hoping someone on this forum may have an idea as to why the below formula is not working. TIA for your help! “=GROWTH(FILTER(Actual_Base_25,(Actual_Country=Regressed_Country)*(Actual_Refinement=Regressed_Refinement)),FILTER(Actual_Grade,(Actual_Country=Regressed_Country)*(Actual_Refinement=Regressed_Refinement)),Regressed_Grade)” Read More