Mike,

Read Chip's response. I have tried what you suggested but it's alot of
extra work with the spreadsheets. Chip's formula works perfectly as long as
there are numbers i.e. 0 or greater, in every cell. Blanks won't work!

"Mike Armstrong" wrote:

Lynne,

I haven't found a filter row solution yet, but this may help to start with
anyways. Select your data and choose to copy it, but instead of just pasting
it, do a paste special and choose the checkbox at the bottom to "transpose".
That will take your row format and change it to a column format that you can
then use autofilter on. When you're done, you can do the same thing in
reverse. Copy the data and Paste Special and transpose again. Hope this helps
as at least a temporary fix.

"Lynne" wrote:

can this be done? I have 12 entries in a row...need the top 10 averaged,
lowest 2 discarded.