Using tiebreakers is frequently required in sports leagues and sales data to come up with winners and losers. We can use a clever trick to rank with tiebreakers, a process otherwise made difficult by the many conditions.
Here we have sales data for automobile salesmen, and we want to grant...
Please help! I've tried so many different things and have had no success. That said, I'm sure I'm missing something simple. I'd like to set up a ranking column based on multiple criteria where ties skip a number and there are no duplicate rankings. Right now my formula gives the same ranking...
I am working with a large data set. The values are included in two different columns. A lot of the values have very little value to the overall report impact. What I want to do is identify the top 10 items by percentages that have a number greater than 50 in my top 10 table separate from the...
I am new to DAX and struggling to find a formula to show me the top 10 customers then all others grouped together under "Others", as i want a clean looking
the field names are "SupplierName" and the values are "YTD Sales"
not sure what other information is required.
I am trying to figure out how I can pull some data over in a specific way to ensure that it matches my criteria.
I have my source workbook which contains all data for Item, Location, Ranking (based upon location), & Data Points 1-10 (1 through 10).
I also have my template sheet...
I have a table with country performance data & I would like to be able to see the best performing country on a certain date. The idea is that if I change the date in cell E10 (highlighted in red), the formula in E11 would display the country name of the highest value on that date.
In the event...
I'm using this formula in Column A =IF(G3="","",IF(G3=G2,A2,ROW()-2)), which will show a tie for the same rank (i.e. Rank 1 [Bell and Brown] and Rank 4 for both Beckham and Elliott). What would be the formula to rank them 1-5? I would prefer not to show a tie.
Thank you in advance!
Hello, I am looking to fix my formula or understand a better formula to rank titles in one column where the title can appear multiple times with different number of units each time the title appears. Below is an example (Note I only included the rank in column C without the name of the title...
There are multiple threads of Ranking based on multiple columns but still I am posting new.
Please try to help me.
# of Links
# of Links
# of Links
I have a sheet with economic indicators in column A, countries in B, and annual values in C-Z, and in AA I have the average annual value for that indicator.
Indicators repeat for each country, and countries repeat for each indicator, so it looks like:
I have a project that I am unable to figure out the best way how to accomplish. I have five players on our basketball that are having a contest. Each player took 25 shots. I need to rank each player's shots individually. For instance, Andrew made 24 and 23 (4th and 1st attempts respectively)...
Im sure you will be able able to help with the following question:
I am trying to RANK a list of data but where the number maybe the same how can i get the formula to not have duplicates... So far example below i want James to be ranked 4th and Sally 5th even though they both had...
Hoping for the excel gods to answer a question.
I have data in a row like the example posted below. I want to rank the values (including positive/negative numbers), but need to ignore the zero's since a zero indicates no data was present. I can rank including the zeros, but that throws off the...
I have created a Workbook that has a worksheet for each day of the month. Then each day there is a log of events setup with Providers listed down col A and possible events listed in the top Row. On the last worksheet I have the monthly totals which I have formulas showing the monthly total...
Thank you in advance for helping with this, I have been searching for 3 days now and cannot seem to find the magic formula.
A1:A3, A4:6, A7:A9, A10:A12, A13:A15 & A16:A18 are merged in the actual spreadsheet.
Column F is the results I am wanting returned. I need F1, F4, F7, F10 & F13 to...
In the below example i need to only rank the topline (bold records) and ignore all the other values from the value column when ranking. The excel rank formula ranks "office" as 3 because "detached" (which is a row to be ignored when ranking) has a higher value. It should however be...
I am trying to rank 48000 rcds and on running query Access just hangs.
Any suggestions to overcome this situation? I can reduce my records but dont wat to if possible.
Any other suggestion for ranking these many records?
This is for a school. I need to rank the students based on family information.
FamilyID = one ID per family
StudentID = unique student ID
Grade = student's grade
TeachingFamily = binary, do they have a parent who teaches at the school
Status = are they a Full Time or Part Time? (not binary, as...
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...