Formula problem: large() small()

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with dynamic tables 3
Another Hide Columns Question 2
find the matching and supply the quantity 1
find the item and supply the required quantity 3
SMALL function seems not to work correctly 13
count formula 2
VLOOKUP or SUMIF for Multiple Criteria 2
Complex Lookup Formula 3

Top