Apologies in advance if this has been asked and answered elsewhere, but I couldn't find it.
I have a table of parcel lot lines. I've sorted them by parcel number and length. Now I need to add a field that ranks them by length for each unique parcel, so it would look something like this:
| Parcel number | Length | RankByLength |
|---|
| Parcel1 | 30 | 1 |
| Parcel1 | 35 | 2 |
| Parcel1 | 100 | 3 |
| Parcel1 | 102 | 4 |
| Parcel2 | 38 | 1 |
| Parcel2 | 40 | 2 |
| Parcel2 | 90 | 3 |
| Parcel2 | 91 | 4 |
I would think it's a pretty small bit of code to do it, but nevertheless still beyond my capabilities.
