Results 1 to 7 of 7

Thread: A Question Concerning The Percentile Rank Function In Excel 2007

Threaded View

  1. Mar 15th, 2012, 08:49 AM #1
    Hack
    Hack is offline

    Thread Starter
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    A Question Concerning The Percentile Rank Function In Excel 2007

    I have a two part question concerning Excel’s PercentileRank function.

    1. How do I deal with #N/A returns? Every example I’ve found through Google searches provides code for dealing with a #N/A return when using VLOOKUP.

    2. Most importantly, why do I get that at all? I have thirteen columns representing metrics and I need to percentrank. I have a total of 2, 438 rows for the thirteen different metrics (which in the real world represents individual medical practices)

    Some columns will give me a valid return for all 2,438 rows and some will give me #N/A for all 2,438 rows. I’ve attached a sample which represents my problem.

    Is this a data issue or a lack of understanding on my part regarding how PercentileRank works issue?
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width