I am trying to bring these 3 functions together with frustrating conclusions.
I have a worksheet of 3 columns: Territory (A), Sales Rep Name (B) and Expense Amount (C). On a separate sheet, I want to show a list of the top ten spenders (two columns--Name and Expense Amount) in order from high to low for a given territory that the user will select from a drop down box.
Is this possible with these functions?
Much thanks.
Bookmarks