Hello,
I have the attached file. On the entire report tab in column k AU I have a rank formula that assigns the data a rank from lowest to highest based on one of the other columns. On the summary tab I have an index match formula that is supposed to go to the entire report tab and pull the top largest and another section that pulls the top lowest based on the rank. The formula on the summary tab is pulling a result but it isn't starting with the largest number. I cannot figure out what is wrong. Any help would be appreciated.
Bookmarks