Find repetive data and calculate

T

Ty

I have a Sheet 1, column A with random multiple items/data, some repeated.
In Sheet 2 Column A, I have a clean list with no repeats of those items. I
need a formula that will identify how many times an item appears in Sheet 1
column A. Ex. if ABC123 appears 14 times in column A. I would like my
output to show: ABC123, 14
Thanks, Ty
 
P

Paul C

Use a Countif in Column B of Sheet 2 (this would be the formula for cell B1)

=COUNTIF(Sheet1!A:A,A1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup and Replace with value 1
Excel Dragging countif formula with changing criteria 3
Need formula to add cells with same group 1
Reference Formula Help 1
Formula Help 1
formula help 5
Calculate Items Per Hour 4
lookup and Replace with value 4

Top