Formula problem: large() small()

  • Thread starter Thread starter Sabine
  • Start date Start date
S

Sabine

I have a table with the following data:

Sales CostofSales GrossProfit SellExp
Store1
Store2
Store 3
Store 100

In a separate table, I would like to create a summary that
only shows the five largest and five smallest values in
each column with the corresponding store # next to it.
Some columns might have identical values for multiple
locations.
Thanks
 
Back
Top