Forum Discussion
Help with filtering list of words
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... AUD AUD AUD BBD BBD BBD BBD BRL BRL BGN BGN BGN BGN CHF DKK DKK ...
You may write the formula as below.
=Choose({1,2},unique(List),Countif(List,unique(List)))
=Choose({1,2},unique(List),Countif(List,unique(List)))
Starrysky1988 Can you apply the formula to the attached excel file, please
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)))
- How do I use this formula again for a different list?
- Perfect thank you Starrysky1988