+ Reply to Thread
Results 1 to 2 of 2

Percentrank gives me #N/A

  1. #1
    Registered User
    Join Date
    07-09-2012
    Location
    Berkeley, California
    MS-Off Ver
    Excel 2013
    Posts
    33

    Percentrank gives me #N/A

    Hi all,

    Hoping someone could help me with this. I am analyzing employee data using percentrank. I have a list of comparator employees in rows B5:B77, and the employee I am comparing is in cell B3. I enter the function: (=percentrank(B5:B77,B3) and get a percent rank, just as I should.

    The problem is when I use the exact same formula with a different subset of employees. When I enter the function (=percentrank(B5:B9,B3), it returns #N/A. Why would this be? The only thing I have changed is the number of comparator employees. Something about lessening that number is messing me up.

    As always any help is appreciated.

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Percentrank gives me #N/A

    use iferror function in front of the formula

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1