comparing two columns with multiple entries

[Batta2021]

Hello guys,

how to compare these two columns and find the difference in the number of new entries, meaning to find out that there is 1 "11" entry more and 2 more and 2 "13" entries more in column B, compared to column A. I know that finding duplicates does not work neither the way of finding duplicates using countif function (at least not the one I know about) since we have here duplicates within the same column as well as in both columns.

A B
11 11
11 11
11 11
12 11
12 12
13 12
13 13
14 13
13
13
14

Thanks you very much for your time.
PS. sorry, it seems that the data within columns got disarranged whenever I post, but I hope you can get the point of my question.

Batta

[gue2013]

you need a list of unique values.
then you can use countif(..columnA..) - countif(..columnB..) for each unique value

[Batta2021]

Thanks but I don't think that would work, since there are no unique values here, but point is to count newly added (the same) values. Sorry, I have noticed now that the data set I submitted was rearranged: So there as not unique values, just the number of of values is different in columns A and B

[gue2013]

according your sample you have following unique items: 11, 12, 13, 14 (derived from values in A)

see attachment

if you use named ranges or even better a table then the formula for unique values need not be adopted

[Batta2021]

Thank you very much for your time, this should work for me perfectly,

Sincerely
Batta