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.