Most valuable professional
  • Hot Topics

Excel Excel MVP needed! Please help with an (Aggregate) RANK

I have a sample workbook (attached by link) that has 5 worksheets of raw data. Column A contains dates (9/3/2013 - 10/24/2013). column headers are categories/variables (ie: sales, units, etc...) I need a formula that will will give the me the rank for a date (10/24/2013) of of all the aggregate "sales" columns from the 5 worksheets please??? (Caveats... It cannot be broken down into 2 steps... i can't add columns) An Excel MVP is needed please. Last edited by collegeitdept; Oct 24th, 2013 at 07:42 PM.

This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of October 24, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel