I have a line feature class of streets that has been intersected with overlapping polygon "selection areas".
For each selection area, I aim to calculate the rank (1-n) for the streets from longest to shortest within the selection area as I have done for the selected records in the image below.
I had naively suggested that it would be a quick "summarize" operation, but now that I'm actually working on it, there is no built-in function as far as I can tell.
I have tried to manually iterate through summarizing "selection area" for the maximum length value, but this is prohibitively long at best. And at worst, I miss a step along along the way and have to start over.
Can you suggest a field calculator function that will calculate the length rank of each street for each selection area?
UPDATE: I can do this in excel as follows, so I can move forward in my task. But I do still want to know if/how I can do this in the field calculator interface or ArcMap in general
=1+SUMPRODUCT(($B$2:$B$13469=B40)*($C$2:$C$13469>C40))