Hello everyone,
I have an excel file like table below. I want him to extract me only the unique items from "Source" column and then to count them in "Ocurences" column.
I did it with with DATA--->Advanced--->copy unique entries etc.
and then countif...
but this xls has 8000+ rows, so it crashes when I try to do it in this way... Any macros or suggestions how to do it?

I have an excel file like table below. I want him to extract me only the unique items from "Source" column and then to count them in "Ocurences" column.
I did it with with DATA--->Advanced--->copy unique entries etc.
and then countif...
but this xls has 8000+ rows, so it crashes when I try to do it in this way... Any macros or suggestions how to do it?
