Create 2 Tables with Unique values Sorted in specific Order

[Hesham121]

Hello Dears,

I'm trying to automate extracting 2 tables Stacked side by side to each other as attached and sorted in a specific order.

Each table contains the trips where the "In-S=1" column in the data table

- Table Header is the Unique location where the Trips start from per direction and it should be sorted based on the earliest trip time.
- Then add the most common/repeated location where the Trips are ending (It should be 1 Location)... For example, in Direction 1, Most of the trips are heading to a location called "KIT2".
- Then inside each table list the sorted trip numbers under the "Trip Number" column per direction.
- Then add the start time under the trip start location and end time under the trip end location.
- Then add the Headway for each trip.

I've tried the below formula to create the table headers but it didn't return the expected results.

Please Login or Register  to view this content.

Appreciate your support, Thanks in advance!

[windknife]

Maybe

Please Login or Register  to view this content.

[Hesham121]

Thank you!

I've edited it to be like this to put the most frequently occurring location in the [To] column

Please Login or Register  to view this content.

[windknife]

You are welcome.
-----------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

[Hesham121]

I've done almost everything, but I need your help to fill the start time for each trip based on the start location and the end time based on the end location in each table as attached

[windknife]

Ok, I try to solve it, but I haven't optimize it ^_^
Maybe, you can combine all formulas.

D3

Please Login or Register  to view this content.

G3

Please Login or Register  to view this content.

K3

Please Login or Register  to view this content.

M3

Please Login or Register  to view this content.

[Hesham121]

Thank you so much, I'm marking it as SOLVED

[windknife]

You are welcome.