Difference in totals

In “My collection”, I have 16,477 items, but have 16,476 different items, with the word 'items' meaning coins.

As I collect by type, somewhere within the 16,477 items, I have a coin listed with a quantity of 2, which I do not want.

How do I quickly find this minor error, so that both numbers are 16,476.

Thanks in advance

coinman1 (Geoff)

 Export the collection in an Excel list and quickly see where the 2 is. 

By sorting the quantity column in number order; the 2 will be at the top. 

https://en.numista.com/vous/export_form.php?type= 

Unless they are the same type but different variety.

 On the profile if the collection had been viewable, 

I could have looked down the list … 

A surefire way to find it is to export your collection to Excel using only the N# number and Quantity. Then, as Zac said look for the 2 in the filter for Quantity. If there is no 2 then you have the same coin type but 2 different years/variety. So, using the same Excel file in column C, Row 3 enter “=A3=A2” (without the “”):

Then drag that cell to the bottom.

Any time an N# is repeated it will return a “True.”

Then on the filter for column C select only True.

And you'll find the one True.

The collection of COINMAN1
16,477 coins, 20 tokens, 167 medals
221 countries • 462 issuers 

 May I ask where the 16,476 is found ? 

16477Items

2125Items to swap

16476Different items

These numbers are found on the collection tab

Although some coins show I have 2 on them, they are listed with different catalogue numbers

Some coins like the German €2 coins, which are minted by different mint, so add a different letter, but keep the same catalogue number, in this case I only collect 1 of this type, irrelevant of the letter.

Tried the solutions as suggested, but got some strange answers, which, in a few cases, gave me 3 coins

16477Items

2125Items to swap

16476Different items

16222Types

216Countries

451Issuers

These are the tabs as copied from “My Collection”

No idea I had medals

I probably should have added to select My collectibles not for swap. Didn't realize you had swap items.  What happens to those numbers when when you use the Not for swap only filter?

I did not include swap items, as I have more than 1 of quite a few of them

Take a look here: N#36459

The two coins in your link are listed under the same photograph but they have different catalogue numbers, so only count as 1

I have just downloaded my collection using the N# and quantity which came as columns A and B. I checked the total listed which was 16,477, but, when I clicked on the arrow in the quantity box, it gave me the follow options

Ascending

Descending

1

This means that there are no coins listed with a quantity of 2, as the “2” should have been shown below the “1”

Yep.  So my method won't work because they are on the same coin page (N#). I didn't take that into account.

Figured out how to do it (I think).

Export My collectibles not for swap, Coins, N# number (with link) and References (the one under Version).  

N# will be in column A and References in column B.  In column C row 3 put "=A3=A2" and in column D row 3 put “=B3=B2” and drag both to the bottom.  Then on the filter for column C and D select only True.

That will do it (I think 😁)

Do I just drag the inputs of columns C and D down to the line of the last coin or below the last coin.

Am I trying to add these inputs to each line 

Just drag them down to the last line.  It might take awhile to go down 16 thousand lines.

Edit:  Wait!! Look here first N#43609

rsirian1,

You have solved the problem.

I noticed when I looked in my profile page that at the bottom of the list that tells you how many commemoratives, circulating commemoratives and so on, at the bottom of that list was coins with a quantity of 2. The other lines I could open, but not the bottom one.

My quantities are now equal at 16,475.

I have no idea how unidentified coins were added, as I have never done that since I joined Numista.

Many thanks to all

Geoff (coinman1)

You're welcome. Relying on the old saying “it's always i the last place you look” I decided to start at the bottom of the list and work to the top.  There is was, the last in the list.

What you have are probably two coins that were moved there by the Admins when a coin page was modified or deleted and there was no good place to move them to so they were moved to this catch all page.  Now the question is, can you figure out which two coins in your collection were moved there?

I am 73 years old so do not think it is even viable for me to think about searching for this particular coin or whatever it was.

As I said earlier, I have never selected anything that does not exist, but gone onto the forum and asked first. I have added over 2,000 coins to the Numista site, so would add not any unspecified coins. As I have never added unspecified coins, I have no idea why the administrators of this site could add this item to my list.

Many thanks again

It was not added it was moved. In the past when no ‘unidentified’ yearlines existed many coins that only had a generic yearline that later got variant yearlines were moved there as you can not know what subtype the people have and you can not simply delete a collection entry. But usually the year line comments were preserved and country names were additionally added.

If changes like that are made by senior members of the Numista administration why are these changes not announced, so that we all know what has happened, and we are all kept up to date, and not find out about them when we discover it for ourselves, possibly months after the changes were made.

Probably because there is no broad cast system outside of forum posts most people won't read, also your case would probably be quite a few years in the past as of now.

COINMAN1

If changes like that are made by senior members of the Numista administration why are these changes not announced, so that we all know what has happened, and we are all kept up to date, and not find out about them when we discover it for ourselves, possibly months after the changes were made.

You can add your vote and opinions here:  https://en.numista.com/forum/topic169841.html

Vote added, but as the original idea is 6 months old, I would guess, perhaps confirm, that nothing has been looked into doing something about this

Since it's in OPENED status it's still alive and with 34-0 for it probably will be done. Sometimes it's just a priority issue.