Trying to create a rank? formula for the following data example:
(A) (B) (C)
| Quotation # | Version # | Expected result |
|---|---|---|
| 1 | 222222 | 8 |
| 2 | 222222 | 9 |
| 3 | 333333 | 2 |
| 4 | 333333 | 3 |
| 333333 | 4 | 3 |
ie. rank the version # for the unqiue quotation number
Thanks in advance!
Tried some many formulas but can’t get it to work. Help!!
New contributor
Kate Joseph is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.