I need to determine all combinatons of data to build a an array that will display the combinations so that calculations can be done to determine all possible combinations per city.
Columns A:G orginal data
Columnes I:J - possible combinations calclations
Col(L:R) results of combinations for the city of Paris.
the approach I was thinking was to build on the fly a query using for loops or an array to determine all possible calculations for each row of data. All suggestions are welcomed/
so I need to programically determine all possible combinations, see example. I was hoping you could help me to write the code to return necessary results.