Hi guys,
I'm working on a table of Weekly Apple sales for my job. What I'm trying to figure out is how to generate a List of Top 5 Total Sales Items.
Column A = Apple Varieties
Column B-T = Sales of each variety for individual weeks
Column U = Total Sales
Column X = Highest Sales
What I need is a formula that will rank the five highest numbers in Column U and output the name associated with each highest total in Column X. Gonna keep tinkering with it, but any help is appreciated. Thanks.
~Dustin
Bookmarks