CREPOSUC
Joined: 10-Jun-2012
Posts: 2785
Posted: 24-Feb-2018, 08:27
#
Posted: 24-Feb-2018, 08:27
#
How many countries do you have ? Which ones ?
How many countries are you missing ? Which ones ?
Proposed on the French forum you will find
HERE in free download of the english version of an little Excel 97-2003 application, tested with XP-SP3, verified by Norton360, which will tell you.
- -At the bottom of the page 'My collection' scroll down the list 'View the country list with my collection quantities',
- -position the pointer in front of the C of Countries and Territories,
- -without moving it go to the end of the list with the vertical cursor,
- -hold the shift key pressed to point on back of the last country (Seborga), you have selected the entire list,
- -do CTRL + C (or Edit-Copy),
- -then click on the 'My Coins' button on the Excel sheet.
That’s done .
If you have coins in sub-sections you will have developed them before with the 'See sub-sections' to go from 544 countries to up 1324 transmitters.
The process is the same to update the result.
if it can serve (with translator, I speak only french)
ngdawa
Joined: 18-Oct-2011
Posts: 5587
Posted: 24-Feb-2018, 10:51
#
Posted: 24-Feb-2018, 10:51
#
According to my documents I have 287 countries and territories, but do you want a list of it all as well?
Coin referee for: AZE, FRO, GRL, US-HI, KOR, KGZ, MLI, MHL, MMR, PRK, UZB, SML, TAT, TWN, TJK
Banknote referee for: AGO, AZE, BLR, ECS, GEO, HTI, KAZ, KGZ, KOR, MNG, MRT, PMR, PRK, ROK, SWE, TJK, TKM, TUR, UZB, WSM, ZWE
CREPOSUC
Joined: 10-Jun-2012
Posts: 2785
Posted: 24-Feb-2018, 11:49
#
Posted: 24-Feb-2018, 11:49
#
No thanks, it's for you,
you miss it between 357 and 1137
you can see which one
CREPOSUC
Joined: 10-Jun-2012
Posts: 2785
Posted: 3-Mar-2018, 10:32
#
Posted: 3-Mar-2018, 10:32
#
W10 Excel2013 .xlsm version
HERE
MihajloNesic
Joined: 2-Jul-2015
Posts: 313
Posted: 3-Mar-2018, 12:43
#
Posted: 3-Mar-2018, 12:43
#
You can check mine on my web page!
Edit: 185 Countries, 202 Issuers
CREPOSUC
Joined: 10-Jun-2012
Posts: 2785
Posted: 3-Mar-2018, 18:26
#