+ Reply to Thread
Results 1 to 2 of 2

Problem with RANK formula

Hybrid View

  1. 10-07-2023, 07:18 AM #1
    Navin Agrawal
    Navin Agrawal is offline
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2019
    Posts
    327

    Problem with RANK formula

    Hello friends,

    I am having an issue with the RANK formula...

    I have used the regular RANK formula and I have used by adding the countif formula to RANK... getting an error in both

    Attaching a sheet for the issue...

    Pls help
    Attached Files Attached Files
    Regards,
    Navin Agrawal
    Reply With QuoteRegister To Reply
  2. 10-07-2023, 07:30 AM #2
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,918

    Re: Problem with RANK formula

    I would guess this is a floating point issue in Excel because if you manually retype all the numbers to two decimal places, it all works as expected.

    BSB
    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. Formula Rank.EQ problem still found duplicate value
    By riagil in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-23-2017, 04:46 AM
  2. rank formula problem
    By pedersenn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-16-2016, 04:19 AM
  3. [SOLVED] Ranking Help - Rank formula to exclude data from ranking (like a rank if kind of function)
    By harp1983 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2016, 06:55 PM
  4. [SOLVED] forcing a rank on 1 through 5 (no dups) using the rank formula in Excel
    By denver1717 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-22-2015, 08:28 AM
  5. [SOLVED] RANK formula cannot rank duplicates
    By unpluggedmusic in forum Excel General
    Replies: 5
    Last Post: 10-13-2012, 12:59 PM
  6. 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
  7. [SOLVED] Excel 2007 : Problem with repeated value in RANK formula
    By Navin Agrawal in forum Excel General
    Replies: 4
    Last Post: 07-12-2012, 08:20 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