I found Dave's thread on how to count cells by fill color and I am using ColorFunction.
http://www.ozgrid.com/forum/showthread.php?t=27182

I have also found how to count the unique values in a column.

Now what I need to combine them to look at the yellow cells (fill, not font) and tell me how many unique values there are. There are no blanks in the column.

For example. I need th following to return 3, not 5.

tshqas193a
tshqas194b

dvhqas055
dvhqas143
dvhqas323
dvhqas046
dvociw001
dvociw001
dvociw001