Hi All,

Im not even sure if this is possible, but lets say i have two columns A and B. Column A is State (ex TX, CA, etc) and Column B is a whole number 1, 2, 3 etc. I want to calculate the Mode for each state. Ex if i have 5 people from TX and Column B for each of them are 1, 2 , 1, 1, 5, the i want to return a 1. I just don't want to go through and do it individually for each state. Is this even Possible?? thanks for the help.