Cool! Thank you very much Max, this did what I needed!

"Max" wrote:

You mean the recalc performance?

For recalc efficiency ...
Put in B2: =IF(x!A2=$A$1,x!C2-ROW()/10^10,"")
you could copy just the criteria formula in B2 (above) down to cover the max
expected extent of source data, eg down to B1500. The criteria formula is the
only one which needs to cover the full extent of the source data.

As for the extract formulas in C2:D2 (these are the "heavy" crunchers), just
copy down by say, 10 rows to D11? would probably suffice for your purpose of
determining the "Top 5", allowing for the possibility of a couple of
ties/multiple ties.

Above should do it ok for you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"stevedemo77" wrote:
Thanks Max, your method works, but here's the challenge. I have 40 dynamic
regions, and almost 1500 salespeople to choose from. Is there a way to
filter the 1500 rows of data by an off-sheet reference, such as the region
value in cell A1 of another sheet?