Apr 07 2022 12:57 AM
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,
Apr 07 2022 01:06 AM
Apr 07 2022 01:51 AM
@Starrysky1988 Can you apply the formula to the attached excel file, please
Apr 07 2022 03:16 AM
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)))
Apr 07 2022 06:44 AM