I'm about to get started on working with a dataset of ~80.000-100.000 rows and 12 columns.
I have to decide on the approach first though.
To make it simple, I have to summarize the data on various filters (lets say car types). How many were sold in which month etc.
The car models are dynamic - one day I'll have 10 of them, another 50.
Is a looping approach favorable in this situation? Or should I perhaps think about steering a pivottable with vba and copy paste the desired results?
Or does anyone have better ideas?