+ Reply to Thread
Results 1 to 5 of 5

Formula to RANK groups of values.

  1. 12-10-2014, 11:10 PM #1
    hammer2
    hammer2 is offline
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Formula to RANK groups of values.

    Hi Folks
    I have attached a worksheet to detail my requirement.
    Note that this is an alteration to a formula I am currently using.

    Cheers
    hammer
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-11-2014, 12:17 AM #2
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Formula to RANK groups of values.

    Hi,

    Use this formula :

    Please Login or Register  to view this content.
    Regards
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  3. 12-11-2014, 12:42 AM #3
    hammer2
    hammer2 is offline
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: Formula to RANK groups of values.

    Hi karedog
    I get an error message with that formula 'you have entered to few arguments etc'
    Reply With QuoteRegister To Reply
  4. 12-11-2014, 12:46 AM #4
    hammer2
    hammer2 is offline
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: Formula to RANK groups of values.

    Okay, got it, I typed it in incorrectly d'oh
    Many thanks for your time and expertise
    Hammer
    Reply With QuoteRegister To Reply
  5. 12-11-2014, 12:50 AM #5
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Formula to RANK groups of values.

    You are welcome Hammer, and many thanks for the reputation points.

    Regards
    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 values in one column from groups of numbers in another column
    By fruit&veg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2014, 03:48 PM
  2. [SOLVED] Rank values in one column from groups of numbers in another column
    By fruit&veg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2014, 01:04 PM
  3. 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
  4. Rank items within groups
    By Kyle Hansen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2009, 11:53 AM
  5. [SOLVED] One list unsorted, but two groups - I need to rank in each group
    By Skiffie in forum Excel General
    Replies: 0
    Last Post: 08-21-2006, 03:15 AM

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