• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

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

1 Solution
Saqib Husain, SyedEngineerCommented:
Enter this in B2 and copy down

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now