tie

Hi, I am seeking help in a formula to show the results from evaluation that either shows if the consensus is either Exceptional, Satisfactory, Unsatisfactory or if it the outcome is a tied result based on the evaluation selection from other cells. Column "O" should show the consensus of "K-N"...

Hi there... I am having a bit of trouble with the formula below which is intended to provide a unique (no duplicates) ranking of Productivity scores (highest to lowest) using another metric as tie breaker as needed (lowest Score is best). The formula is used in cells AM7:AM31 and the tie...

Hello, I am needing to rank a table that has columns for Names, Point Totals, Avg Race Position, and Avg Qualify Position. The ranking should be by largest point totals, however if there is a tie, the first tie breaker would be by lowest avg race position, and if still a tie, by lowest qualify...

Hai, I have a userform which is driving me crazy. It has a ListBox with a bunch of items and next to it labels that give info about the listbox items but they do not alight properly when I have too many items. I can't figure out how to tie them together or at least make it look like so: Couple...

So I ahve made some progress with the ballot for this coming Saturdays car show. Problem is the formula I use lists the word Tie when there is a tie. I just want it to list the top finisher (30 to be exact) even if ther are ties. Here is the formula...

I'm trying to create a formula to rank the following from lowest to highest with a tie breaker. So far I've come up with this: =RANK(X2,X$2:$X21,0) but it does not work and does not account for a tie. Column X <colgroup><col></colgroup><tbody> 0.17 3.33 2.50 0.83 0.58 3.33 1.00...

I have a list of comma delimited text that I would like to VLOOKUP the values of, preferably without using Text-to-Columns. I would like to use VLOOKUP so that if there is an error I can return "Error". Sheet 1 is my lookup list. <tbody> NUMBER NAME <tbody> C-1032-4 </tbody> <tbody>...

Hi Group, hopefully this is an easy one. When I am stepping thru my code, I get to a line "Workbooks.Open" and as soon as I go to the next step, the code just runs in full to completion without going thru the remaining steps and there is a few left....? Any Ideas why this is happening...

Hello all, Long story short, I have a piece of code here that is supposed to compare two experts in a head to head style on who has more clients. Whoever has the higher number, the code should highlight the cell with the higher total. If they are tied, it then compares a second category, pace...

I have the code that allows me to use Hyperlinks (hyperlinked Words)to a hidden worksheet but I would like to tie the Hyperlink to a shape. Can this be done? Thank you!

Hi. I am trying to rank a range of cells base on certain criteria: Criteria 1 - No ties using column G as the tie breaker. Criteria 2 - Do not rank the columns that state "Not Qualified" Here is my current formula: RANK(AJ9,AJ$9:AJ$18)+SUMPRODUCT(--($AJ$9:$AJ$18=AJ9),--($G$9:$G$18>G9)) G...

I'm trying to work out a formula for ranking but the data i need to rank contains a ton of ties. basically i have a 3 way tie for 1st, a 11 way tie for 2nd, a 8 way tie for 3rd, a 9 way tie for 4th, etc and its making my ranking look confusing. rather than the 4th place rank showing as "4"...

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

Hello, Say I have two worksheets in a workbook. One sheet called TIE OUT, and the other DTSE. I have the following formula in cell L4: =IFERROR(INDEX(DTSE!$A$1:$Q$307,MATCH((EOMONTH(D4,-2)+1),DTSE!$A$1:$A$307,0),L$1),"") What I'm trying to accomplish is have DTSE! be referenced to a cell...

Hi, I have a set of data. Lets say there are 10 people that answer and bunch of questions and based on the questions, there is a formula that calculates 10 separate "scores" that describe the person. So for each person there are 10 "scores" (say Score A through Score J) that range from 0 to...

I am creating an excel file in order to track the history of our football team. The excel sheet has the name of our opponents as well as the score for our team and the score for the opponent. I want to have another column that has a formula to calculate, based on the score, the result with a...

I've searched older threads but can't find an answer to my question. I want to fix a tie breaker in my rank formula. I am currently creating a performance based bonus system for my employees. I gather the data, enter it into a spreadsheet and have a score sheet on a second sheet in the excel...