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