I have a column filled with urls in the chronological order in which they were visited. I want to count instances of each duplicate and list the count alongside the url in a new column to the right, so I can see which pages got the most hits.
I've been able to do this in the past with KuTools for excel, but my free trial ran out. KuTools would count each duplicate and then display the count next to the first instance of each duplicate while deleting the others. It was great and I wish my office would just pay for it.
I want to know if there is a way to do this with formulas or VBA. I've tried using countif and countifs but the problem is that I have to apply the formula for every URL, and there are thousands of them. What am I missing? What can I do differently? Thank you very much for the help!