Forum Discussion

Bielalve's avatar
Bielalve
Copper Contributor
Aug 09, 2022
Solved

Count different texts

Basically I'm working only with column A, where I have several different terms, but they repeat in different amounts. I need to know how many times each of these terms appeared in column A, is there ...
Formulas and Functions
  • Icassatti's avatar
    Icassatti
    Aug 09, 2022

    Hi Bielalve 

    Recentily Microsoft upgrade to Excel's formula language to support https://support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531.

    Now you cold use this simple way to do this

     

     

     

    =UNIQUE(A2:A1812) & " " &COUNTIF(A2:A1812;UNIQUE(A2:A1812))  & "x"

     

    or if you need filter nulable results try this other form

     

     

    =LET(
           rangecells;A2:A1812;
           uniqList; UNIQUE(rangecells);
           filteredList; FILTER(uniqList;uniqList<>"");
           return; filteredList & " " &COUNTIF(rangecells;filteredList)  & "x";
 return
)

     

     

     

    Hope it help you