Capture.GIF
I have the following formula which works for ranking the pick up and drop off order according to the fixed times set (column D).
=RANK(D30,INDEX(D$2:D$33,MATCH($A30,$A$2:$A$33,0)):INDEX(D$2:D$33,MATCH($A30,$A$2:$A$33,1)),1)
The problem comes when in column A the 'route' changes from a single letter to two letters. The Ranking fails to work. I have spent hours without success.
I would appreciate any help on this.
Bookmarks