ExcelBanter - Find repetive data and calculate

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Find repetive data and calculate (https://www.excelbanter.com/excel-discussion-misc-queries/242158-find-repetive-data-calculate.html)

Find repetive data and calculate

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

Paul C

Find repetive data and calculate

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

=COUNTIF(Sheet1!A:A,A1)
--
If this helps, please remember to click yes.

"Ty" wrote:

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

All times are GMT +1. The time now is 08:50 PM.