Formula to Find Maximum Order Total (1 Viewer)

[LadyDi]

I currently have a spreadsheet, where I have listed the customers who have ordered the most from my company during a given month (each month is listed separately). I need to look at the lists for three months at a time and find the customers who have had the largest order volumes for each quarter. Is there a formula that will add the order volume for each customer from those three months and return the top five customers for the quarter? For example: In the attached image, Bank 3 had the most orders and Bank 1 had the second most (so the formula would need to return Bank 3 and Bank 1)


I'm not sure if this is possible, but I knew if anyone would know, the people on this forum would.

 

[Jord]

I'm not sure if this helps but could you use =Rank then lookup against the rank to give you the customers in order?