- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Couting occurences of different text

Subject: | Couting occurences of different text |

Posted by: | PG (paul.gal…@verizon.net) |

Date: | 1 Oct 2003 |

Hello Excelers,

I have a column of text similar to the one shown below. I am trying

to find a way to oount the number of different occurences. In this

case, I have AAA, BBB, CCC, DDD and SSS so I am looking for a function

that would return 5. I dont want to know the number of each, just the

number of different values.

Any help would be greatly appreciated.

Paul

AAA

BBB

AAA

BBB

CCC

DDD

AAA

AAA

SSS

- Re: Couting occurences of different text posted by Voodoodan on Wed, 1 Oct 2003
- Re: Couting occurences of different text posted by David McRitchie on Wed, 1 Oct 2003