+ Reply to Thread
Results 1 to 4 of 4

> HELP with an (Aggregate) RANK formula

Hybrid View

  1. 10-24-2013, 07:48 PM #1
    collegeitdept
    collegeitdept is offline
    Registered User
    Join Date
    10-24-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Question > HELP with an (Aggregate) RANK formula

    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/...0Question.xlsx

    (Caveats... It cannot be broken down into 2 steps... i can't add columns)


    An advanced Excel user is needed please.
    Reply With QuoteRegister To Reply
  2. 10-24-2013, 11:58 PM #2
    collegeitdept
    collegeitdept is offline
    Registered User
    Join Date
    10-24-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: > HELP with an (Aggregate) RANK formula

    Can someone please help?
    Reply With QuoteRegister To Reply
  3. 10-25-2013, 01:55 PM #3
    collegeitdept
    collegeitdept is offline
    Registered User
    Join Date
    10-24-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: > HELP with an (Aggregate) RANK formula

    Any one please?
    Reply With QuoteRegister To Reply
  4. 10-26-2013, 04:46 AM #4
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: > HELP with an (Aggregate) RANK formula

    Maybe something like this ? Rank based on Date ranges...

    Azumi
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] RANK formula cannot rank duplicates
    By unpluggedmusic in forum Excel General
    Replies: 5
    Last Post: 10-13-2012, 12:59 PM
  2. Formula to Rank and populate values base don Rank
    By Excel Dumbo in forum Excel General
    Replies: 3
    Last Post: 10-09-2012, 02:02 AM
  3. Excel 2007 : Formula to aggregate info from 100 sheets
    By Robjenkins in forum Excel General
    Replies: 1
    Last Post: 03-21-2012, 04:18 PM
  4. [SOLVED] aggregate Formula for Excel
    By GSO in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2006, 10:45 AM
  5. Rank items, select one start date, have remaining dates follow based on rank
    By rob normerica in forum Excel General
    Replies: 1
    Last Post: 08-15-2005, 05:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1