Spreadsheet: 816370d1675544690-need-ascending-rank-formula-to-rank-values-greater-than-one-first-and-zero-values-last-book1
Sheet: Individual JR.

 |  |  |  |  |  | Number of test Points without bonus points? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Goal In Column T: First RANK the values from column N that are greater than 0 in ascending order, followed by the values equal to 0. Ties for all duplicate values in column N are broken by column K.  Values will be random, unsorted, with duplicates in real life. I only sorted and grouped these test values for a visual aid.
 |  |  |  |  |  |  | 45
 |  | Correct Number of Test Questions (Don't [NAME]) | TEST Score | Total # of Bonus Points | Emailed Test Points Score | Tie-Breaker (Enter -0.000X to order ties) | Test Place | Test Place Points | Total Points | Overall Final Rank | Barrels Time | Number of 5-Second Penalties | Final Barrels Time | [NAME] | [NAME] | Barrels Placing | Barrels Placing Points | Total Barrels Points | Overall Final Barrels Rank |  |  |  | This is what I want Column T "Overall Final Barrels Rank" to be: |  |  |  |  | I can get the first and last steps correct; that is, I can rank asceding while ignoring the zeros and break ties with column K, but I can't get the zeros to rank last in the correct order.
 |  | 20 |  |  |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  | I conditional formatted the duplicate values in a pink background and red text so they are easily spotted.
Column K is ranking the values in Column J in Descending order.   These columns are working correctly  for me. |  | 19 |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  | 18 |  |  |  |  |  |  |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  | 17 |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  | 16 |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  | 15 |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | 14 |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  | 13 |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  | 12 |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  | 11
 |  | 10 |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  | 9 |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  | 8 |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | 7 |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  | 6 |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | 5 |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 4 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  | 3 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  | 21 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  | 22 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fastest Time in range
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle 3rd breakpoint
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bottom 3rd breakpoint
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Slowest Time in range
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Runs
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Blue Ribbons
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Red Ribbons
 |  |  |  |  |  |  |  |  |  |  |  |  |  | White Ribbons
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Orange Ribbons
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Ribbons