Please see attached. Need formula that will look down column F, rank from absolute highest to absolute lowest and look down column G and rank from absolute highest to absolute lowest and copy top 10, or whatever selected ranking of list to different worksheet. Please note Rank Function formula in column H and column I. Thanks.
20 KB Views: 75