percentrank zeros blanks

  1. G

    Excel and/or Access ranking questions

    Thanks in advance for taking the time to read this! I have a rather large data set, containing over 20,000 records and I am looking to calculate the percentile ranking of 10 to 20 different statistics for each record, in each category, if the statistic exists. Of these 20,000 records, I...
  2. S

    Loop down by group, Loop Across by condition

    This is omething that is fairly easy to do in a spreadsheet by hand. But I am not sure how to write it into a macro as it becomes part of a bigger macro. IN the attached spreadsheet you can see what I am trying to acheive. I aim to use Percentrank by group and then across the columns. There are...
  3. B

    percentrank that doesn't count blanks

    I have an array of numbers that includes blanks and zeros. The zeros are legitimate values, but the blanks are "missing", so they are different. I want a percentrank of all of the values that are not blank. When I run just a normal percentrank function it treats all of the blanks as zero...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top