Discrepancy between website and exported excel file

2 berichten • 65 keer bekeken

Dit bericht gaat over: rapporteer een bug/fout

Status Geopend
Stemmen voor: 0
Stemmen tegen: 0
Hello everyone,

I have been using Numista for some time now and I find it absolutely fantastic.

Collecting coins is a bit slow now, so my last entry is from july and I reached 242 countries then...
I visit regularly and this week my country count suddenly went to 241! Luckily I had exported my coins to Excel. Today I did the same and started comparing the files.
I thought I had found the lost country when I discovered the British West Indies had gone and were now listed under the UK. But when I removed that coin the count still went down 1...

However, when I count my country list in the Excel file I still have 242 countries but my issuer list is 324 while the Numista site says I have 325 issuers?
This is the formula I use to count distinct entries:
=SUMPRODUCT(1/COUNTIF(A1:A5858;A1:A5858))
Tokens and exonumia are disregarded, the count is 242 countries, 324 issuers. Yet the Numista site says 241 countries, 325 issuers:


Any idea would be appreciated!
Since nobody else seems to have 'lost' a country, I did some more searching in my coinlist that's exported to excel.
Found another one that's moved: American Samoa is now listed under United States. When removing my coin from my collection the country count stayed the same, so this is the one responsible for my 'lost' country...

» Forumbeleid

Gebruikte tijdzone is UCT+2:00.
Huidige tijd is 13:54.