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!
|