1 of 1 people found this helpful
Found this old unanswered post.
If you need help on this still...
You'll have to re-calc those top-5 in the second sheet. You can have that on the sheet without displaying any of the components that go into calculating it. Just do it the same as you did on the first sheet. Once you have that rank, use it as a filter on the second sheet, and you'll only see stuff for those top 5.
If you need more help with this, a sample packaged workbook will let me show you what I'm trying to describe.