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.