Forum Discussion

PF2024's avatar
PF2024
Copper Contributor
Oct 31, 2024

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)"

excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Oct 31, 2024

    PF2024 

    It's better to have sample file or at least screenshot (without sensitive information) since the question is not clear. What do you mean under "formula doesn't work"? - it returns an error, or it returns some result which is not one you expected.

    • PF2024's avatar
      PF2024
      Copper Contributor
      Oct 31, 2024
      Hi Sergei. Unfortunately I can't share a sample file or screenshot. The formula above is returning a #value error, but there are no errors in the source data.
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Oct 31, 2024

        PF2024 

        When only guesses. For example, formula could return #VALUE! error if you have texts within range (which looks like numbers) or blank cells.

Resources