I'm cross-posting this from the Google Sheets API group <https://groups.google.com/forum/#!topic/google-spreadsheets-api/bm0mW7WTutg>, where I posted it yesterday. Maybe some of my TiddlyWiki friends here can help me with this, although it isn't strictly TW-related. I'm creating this sample data (example TW here <https://dl.dropboxusercontent.com/s/odu3my97ujyxz4h/SampleData-testing.html>) for our *{{DesignWrite}}* semester project. Here's what I posted in the other group...
I'm working on a little project which necessitates creating some random sample data for testing purposes. The data is based on New Zealand localised demographic information. I've got the 'Person' sheet working perfectly, using the *INDEX()* and *RANDBETWEEN()* functions to select random surnames and first names, even gender-specific first names. Now I'm working on the 'Address' sheet. I want to build random addresses using the same methodology, based on the information in columns E to H of the 'Random Source' sheet. As you'll see in my sheet, I have successfully selected a random *city*. That was the easy part. Now I need to select a random *suburb* within that city, and a random *street* within that suburb. I presume I'll need to use something like the *VLOOKUP()*, *QUERY()*, or *GETPIVOTDATA()* functions, but I'm not sure which, and I'm not sure how. Any advice would really be appreciated. I have made a spare copy of my Google Sheet for demonstration purposes and shared it for editing here <https://docs.google.com/spreadsheets/d/1A27ZVZmNMktJyncfZlHL4g75ZLfhclQFJqGVySEA3cY/edit?usp=sharing> . Thanks in advance, Hegart. -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/ffd9c61d-d72f-44cd-9f70-6b7fdf0f07db%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
