View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
[email protected] stuart@monakee.com is offline
external usenet poster
 
Posts: 10
Default Summing based on N largest / smallest values

Nick, Bob, Peo,

Thanks for all your help on this.

If anyone knows a single cell answer to this then please let me
know...

Thanks again

--------------------------

Niek Otten wrote:
OK.
It took me some time to understand that it is the position column that selects the top 3, not the value of the column itself.
Here is a step by step approach for Volume. Values is similar but with different column.

I'm sure Bob and/or Peo come up with a compact one-column array formula solution; I'm not good at that at all!