Kevin Neufeld
Board Regular
- Joined
- Oct 6, 2014
- Messages
- 50
In column D I am needing a formula to give the rank of Column C as it relates to Column B. The Rank formula will reset when the Lane ID # switches.
<tbody>
</tbody>
Lane ID # | Base Rate ($) | Quote ($) | Rank |
1 | 10 | 15 | |
1 | 10 | 10 | |
1 | 10 | 20 | |
2 | 20 | 25 | |
2 | 20 | 30 | |
2 | 20 | 35 |
<tbody>
</tbody>