Help with filtering list of words

Copper Contributor

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

EUR

EUR

EUR

EUR

EUR

EUR

 

So I want the answer the filter gives me to be 

AUD 3

BBD 4

BRL 2

BGN 4

CHF 1 

DKK 2

EUR 6

 

Many thanks,

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

@Starrysky1988 Can you apply the formula to the attached excel file, please  

@Buzzard2406 

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

Perfect thank you @Starrysky1988
How do I use this formula again for a different list?