Hi all and thank you in advance.

I am trying to put in a set of variables that describe a city. I am using statistics to find the probability of that person thinking of a specific city (almost like 20Q). Right now I am calculating each city's probability based on a value that compiles all previous variable answers. I then have the top 5 cities ranked as most likely.

I want to do multiple sets of this by changing the variables - ie. NFL team/no NFL team etc.

Attached is my file. I am not sure if I need to use VBA/macros or if this can be accomplished with formulas. Thank you again in advance.

Example 3.0.xlsm