waxwing wrote...
I need a simple way to create a set of correlations based on a
criteria. For instance, lets say column A is STATE, column B is INCOME
and column C is EDUCATION LEVEL. There are thousands of records but
only 50 states. To calculate the overall correlation between INCOME
and EDUCATION LEVEL, I'd use the formula CORREL(INCOME, EDUCATION
LEVEL). But I need to calculate the correlation for each state in a
table. How could I incorporate this into my formula?

Try the array formula

=CORREL(IF(STATE="XY",INCOME),IF(STATE="XY",EDUCAT ION_LEVEL))