Re: Order of multiple functions in a formula.

Thank you again for your response.  This is the result from the initial formula I posted.  I want to FILTER and SORT the data and select the columns I want shown.  But, I want to weed out the duplicates in the ROUTE column - to show the each ROUTE only once.  (1DO2,1DL1,DO1, DO2, 1DO3...) Basically, each route has several stops.  I only need one of the stops for each route.  

I have attached the data and the report form.  And again - I am grateful for any help you can provide me.