How do you find the 1st, 2nd, .... nth highest value of a given row or column of cells filled with numbers? Say I have a bunch of numbers in A1 through Z1. I want the biggest 5 to appear on another sheet as A1, A2, A3, A4, and A5.
I got it to work for 1 sheet using MATCH. However, it doesn't seem that MATCH will work if i want to compare using LARGE and MATCH with multiple sheets. Is there a way to do this while keeping the sheets apart?
Bookmarks