Get counts of the duplicates

Hi All,

Attached file sheet 1 has some URL's and i want sheet 2 to show how many times each URL in column "A" was repeated into new sheet
if its once need to get the number

Thanks
query.xls