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