Help with filtering list of words

Question

Hi,Can you help me with a formula that can tell me how many times a word appears in a list in excel?For example...AUDAUDAUDBBDBBDBBDBBDBRLBRLBGNBGNBGNBGNCHFDKKDKKEUREUREUREUREUREUR&nbsp;So I want the answer the filter gives me to be&nbsp;AUD 3BBD 4BRL 2BGN 4CHF 1&nbsp;DKK 2EUR 6&nbsp;Many thanks,

starrysky1988 · Answer

You may write the formula as below.=Choose({1,2},unique(List),Countif(List,unique(List)))

buzzard2406 · Answer

Starrysky1988&nbsp;Can you apply the formula to the attached excel file, please&nbsp;&nbsp;

starrysky1988 · Answer

Buzzard2406&nbsp;Please find the attached.The formula is as below.=CHOOSE({1,2},UNIQUE($A$2:$A$226),COUNTIF($A$2:$A$226,UNIQUE($A$2:$A$226)))

buzzard2406 · Answer

Perfect thank you Starrysky1988

buzzard2406 · Answer

How do I use this formula again for a different list?

Forum Discussion

Help with filtering list of words

Share

Resources