World Population Random Generator

Thanks, Pete!

This solution is closer than anything I've tried, and a lot simplier. But it seems to have a bug in it: the Pitcairn Islands are showing up far, far too often.

Attachment 435124

The Pitcairn Islands have the lowest population of any organized territory in the world - a mere 56 people, accounting for 0.0000000077 of the world population. If the generator assigns probability based on population, it's extremely unlikely that the Pitcairn Islands show up even once in a thousand tries, let alone three times in ten.

I think it's because the Pitcairn Islands are at the end of the list, which is sorted by the B column. Did I make an obvious mistake, or is there some bug in the code?

I can't download your attachment - the system says that it is invalid. Follow the steps given in the FAQ to attach a file, i.e. click on Go Advanced while in edit mode on a post, scroll down and click on Manage Attachments, click on Browse and navigate to where the file is on your PC, then double-click it, click on Upload and Close Window, the Submit Post.

Pete