How to analyze big data with Excel

[waimea]

Hi again Paul,

I have now had a good look at your two conceptual examples and both are breathtakingly good! I am looking at your UDF right now.

However, my data output from my macro is not in the same form. Is there an easy way to change my output macro to suit your conceptual examples?

I have condensed my data to only have 3 metrics.

1. Make my data the same as in your example
2. Make the code aware of how many cities there are

eg. my first batch of cities has 40 cities, the next batch has 59, the next 26 etc.. down to a mere 1 city.

All suggestions are welcome.