ranking data

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...

Hello all! So I am trying to rank a column of numerical data by a given average of the cells: Assume, Column "D" is: <table width="86" border="0" cellpadding="0" cellspacing="0"><col style="width: 65pt;" width="86"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22"...

Hi Everyone, Here is my challenge. It may sound easy but I have not been able to find a solution as of yet. I am creating a template so that when I upload data it auto populates and I have little work to do. Here is my problem: I have a list of Sales and wish to rank them (easy...

Hi, Please assist me in ranking the top 10 agents based on the Units category. I was doing this using the pivot function; but the file size is too huge after using the pivot function. Please suggest an alternate way to deal with ranking issue. I am trying to find the solution using RANK...

I have a long list of categories in Column A with values associated to Column A being added in Column B, C, D, and so on which is listed under the date. Example: <TABLE style="WIDTH: 145pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=194><COLGROUP><COL style="WIDTH...

Hoping for some help on Ranking within Access. I want to be able to rank pricing by "LaneID". I have been able to rank the pricing with the below query, but I don't have any idea on how to differentiate the ranking by a single value, in this case "LaneID". My first pass is below, it just...

Hi there, Could someone please help me. I need to rank the data as below and the result should be just like the last column. i already sort the data based on the date received (column 3) The rank should be base on: 1st the priority level (ascending) 2nd the date to be completed (ascending)...

Hi, I have to following table: <!--This file was converted to xhtml by OpenOffice.org - see http://xml.openoffice.org/odf2xhtml for more info.--><link rel="schema.DC" href="http://purl.org/dc/elements/1.1/" hreflang="en"><link rel="schema.DCTERMS" href="http://purl.org/dc/terms/"...

Hi, I'm looking for a solution to rank data within excel but with a bit of a difference in that i would like the rank to only be between 1 and 10 and go to three decimal places...The numbers range from 50 to around 100000. Has anybody got any ideas? I've tried percentile ranking and standard...