Question [solved]

Hi to all!

Sorry for might be simple question but I cannot understand what do these numbers mean and why they are different (see below marked in red)? Tryed to find the answer in forum but without success.
Thx in advance.

Seems like you have two pieces of one coin type, all the other types just once.

Coins is the total number of coins in your collection while Different coins is the number of different types/years/variants coins you have. In your case it shows you have one duplicate (1312-1311).

filter is set as "Not for swap only". I exported only my collection to excel where column "Quantity" is. Each cell has only "1" inside and 1312 "1"s are in column. Do you know may be the way to detect doubles?

That can happen if you graded the coins differently. Two of the same coin with a different grade will be on separate lines in the excel file but will be counted as the same coin. I don't any easy way to find that coin without going through the collection coin by coin until you find it.

I've been playing and I figured out a way from the excel file to do this. Assuming your excel file is set up so column C is the N#, column E is the year and column F is the mint mark, put the following on the top coin row (row 2) in an unused column:

=(C2=C3) + (E2=E3) + (F3=F2)

then carry that down all the rows. This will compare the coin type (N#), year and mint mark with the coin on the next row. If all three are the same then it is a duplicate coin and will result in a value of 3. Find the 3 in the file and you find the duplicate.

Quote: "rsirian1"​=(C2=C3) + (E2=E3) + (F3=F2)
​

​Wow. I should come to numista earlier because I have checked coins in excel file by eyes and found coin which is graded differently. So the coin adds +1 to total amount of my coin collection. You were absolutly right and your formula perfectly found the same coin just within a minute. I spent may be an hour... Thank you very much for your help.