tie breaker

  1. D

    Calculate Recurring Items

    If I have a spreadsheet like this (below), is there a way to display the top recurring item (from cells A, B and C) in the cells in Column D, like so? I added notes on the right side. <tbody> A B C D 1 Group A Item(s) Group B Item(s) Group D Item(s) Top Recurring Item 2 Apple...
  2. H

    NEED HELP: Countif tie breaker with multiple tie breaker criteria

    I need a formula that will help me rank the 'Jan Var. for rank only' values, ignoring blanks in between rows, in ascending order. So the largest negative will get rank 1, etc. Then if the values in that column are the same, I want to break the tie by looking at which row has the larger number of...
  3. M

    Top Subset of Category with Most Recent as Tie Breaker

    I'm trying to pull back (based on Customer Number), their #1 Case Reason based on volume of cases, and then when there is a tie (like for 3CTI001-S or 3RTT001), bring back the most recent Case Reason as the winner (from the top tied groups). I'm thinking there are some arrays and countifs...
  4. R

    Fantasy football playoff bracket with tie breakers

    I am trying to create a fantasy football playoff bracket to see what needs to happen in order for teams to make the playoffs. First, so far, I have the team standings, and there are 3 weeks left in the season. The team with the highest record from each division makes playoffs, and the next best...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top