Is there a way to get an average of the top 10 records (or bottom 10) in a
column of numbers (sometimes formatted as $'s sometimes as %'s), other than
sorting and counting ten cells?
The cells are already defined in the function MAX(A1:A220) and I was hoping
to just replace the "MAX" with the appropriate function(s).

Thanks!