Large function with multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a file of monthly sales by type, department, customer, and
division. This file will be updated monthly. My challenge is to create an
executive dashboard that will update automatically when the new data is
uploaded. Formulas can be complex, but must be dynamic so that they do not
require any input from the user when the new data is uploaded.

The items I am struggling with are the top 10 lists. They want to see the
top 10 customers -- easy enough, but then they want to see the top 10
customers within each division (select the top 10 customers where division =
"A"), then they want to see the top 10 customers for each of the product
types
within each division (select top 10 cusotmers where division = "A" and type =
"B"), etc. I can't figure out how to use the LARGE function with multiple
criteria. I think I should imbed an IF statement (or two), but can's seem to
make it work.

Thanks for any help you can offer.
 
You should be able to accomplish this with Autofilter.

You can set, let's say Sales, to show the top 10, and then set the division
filter to the division of your choice.
 
Thanks for your reply, but that actually won't solve the problem. I need to
show several different "top 10" lists on a separate worksheet. This is for an
executive summary. I think I need a formula approach that doesn't require the
reader to actually do anything. They just need to be able to view the results
at a glance. I want the summary sheet to update each month when we load in
new data. That is why I was trying to use the LARGE function. I am open to
any other suggestions.
 
Back
Top