View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DTTODGG
 
Posts: n/a
Default Drop 2 high and 2 low - help!

Hello-

I need to take 7 numbers (each in separate cells) (they could be the same),
drop the 2 highest and 2 lowest and then add the remaining 3.

Can you help me?
4
3.5
5.5
4.5
4
3
5.5
=====


Thank you