Hello all,

Just need a little help with a formula to count the number of unique values within a list.

For example, I have this list:

Text1
Text2
Text3
Text4
Text4
Text5

The formula would need to return the result of 5. "Text4" would only be counted once since it's a duplicate.

Any help is most appreciated - thanks!

Question also posed at Mr Excel: http://www.mrexcel.com/forum/showthr...99#post2716199