Forum Discussion

  • schiasson's avatar
    schiasson
    Copper Contributor
    Dec 01, 2021

    Juliano-Petrukio 

     

    Thanks but unfortunately that does NOT fix the issue.
    I think (?) you locked the reference range in the COUNTIF ?

     

    - but when I add a bunch more skills to the employee and make the UNIQUE list longer → the count is still locked to the original range.....
    * at least the count is working thank you I could not even get that done

    can this count a dynamic range appearing in the category column?

     

    • schiasson's avatar
      schiasson
      Copper Contributor
      Dec 01, 2021
      SOLVED.

      Set count range locked to longest possible list in column.

      Thanks
      • Juliano-Petrukio's avatar
        Juliano-Petrukio
        Bronze Contributor
        Dec 01, 2021
        Its good to know that it worked. So please flag it as solved and hit the like button.

Resources