Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
94
Views
Topic starter
may i know how to achieve below scenario in excel? 1. type company "A" name --> display a list of company A operating routes (origin to destination) 2. select a routing (a pair of origin and destination) --> display a list of company operating on the selected route. Would be helpful for many if there is such kind of tutorial. Thankful for my heart.
Posted : 02/07/2021 12:05 pm
Hi Khine,
Just select your range, press Ctrl+T (or from ribbon: Insert>Table), add a new column with origin and destination combined, then all you need to do is to use the column filters to filter the table.
Posted : 03/07/2021 1:15 am
