breaker

  1. M

    RANK(SUMPRODUCT Unique Ranking With Tie Breaker Problem

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

    Rank lowest to highest with tie breaker

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

    Password breaker

    Have any of you come across a password breaker that can unlock single sheets in a workbook? I have a large workbook from a previous project, several years ago that I have password protected. There are over 150 sheets in the workbook, each sheet is protected individually. I have run the common...
  4. M

    Conditional Ranking

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

    Inserting numeric cell value into cell containing text.

    Good morning, I am working on a LOTO project. I have a cell with the location of my circuit breaker that has the following contents: 23, 25, 27. This circuit breaker information is located in cell E2 of my spreadsheet. The cell I would like to insert E2's contents into has the following...

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
Back
Top