Count Unique in a column

Thanks. that worked. I dragged it down 40,000 rows and it worked but when I try to copy paste values it freezes excel. Is it too much to paste values over? Thank ye.