Just a simplified version of what I want to do.
Cells A1:A50 contain various names in alphabetical order.
Cells B1:B50 contain number values, anything from 0 - 1,000,000
Cells C1:C5 contains 5 of the names from A1:A50 but are changed weekly
Now, in D1:D5, I want to show the names from A1:A50 that have the highest values in B1:B50. Here's the problem. The names in the exclusion list (C1:C5) will still have values in the B column. I want a formula that ignores the names from C1:C5, even if they have 1 of the highest 5 values in the B column.
Edit: Alternatively, display the top 5 values from B1:B50, again ignoring any value that is generated next to the excluded name.
Bookmarks