Finding average of values that are not numbers

[kyopsis23]

I want to find the average of some values, which is easy to do with numbers, but what about non numbers? for example:

blue
blue
orange
purple
red
blue

If I had a long list of that, is there a function that can find me the average of the most common color? I've looked and looked and googled and cant seem to find what Im looking for, any help is greatly appreciated

[mhopps]

=INDEX(A1:A6,MODE(MATCH(A1:A6,A1:A6,0))) its an array formula so enter using "Ctrl+Shift+Enter"

[oeldere]

You can use pivot table for that.