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??? https://dl.dropboxusercontent.com/u/15717201/Excel%20Question.xlsx (Caveats... It cannot be broken down into 2 steps... i can't add columns) An Excel MVP is needed please.

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