Hi,
I have two Ranked Columns
Example:
A B
1 3
2 4
3 1
4 1
5 5
6 1
7 2
I need to search COLUMN "B" For Highest Rank, and then once that is found, I need to have it tell me which of those have the highest rank in Column "A"....
So in this instance, it would...