[diggeryo]

I'm trying to figure if there's a formula I can use in Excel 2003 that will count the number of unique words that appear in a certain column.

For example, in the file in question, column A has a list of songs and column B has a list of artists. Obviously since artists write more than one song, an artist might appear more than once in column B. I'd like to add the number of different artists that appear.

So if this were my Excel file...

COL A - COL B
Brown Sugar - Rolling Stones
Start Me Up - Rolling Stones
Light My Fire - Doors
Iron Man - Black Sabbath
---------------------------------------------------
...the result for the formula would be 3, since there are 3 unique artists in column B.

Thank you for any advice.

mike.

[Advertisements]

Say, we need to count the unique words in B1 : B4, try the Array Formula
=SUM(1/COUNTIF(B1:B4,B1:B4))
(To enter an Array Formula we need to press Ctrl+Shift+Enter, rather than just press Enter)

[paper]

Say, we need to count the unique words in B1 : B4, try the Array Formula
=SUM(1/COUNTIF(B1:B4,B1:B4))
(To enter an Array Formula we need to press Ctrl+Shift+Enter, rather than just press Enter)

[diggeryo]

I can't believe that worked. Thank you so much! And here I thought it was a futile quest to find a formula to do what I wanted it to do.