Log In
Register
Home
Search/Filtering function for required info
khine PS
New Member
Members
Forum Posts: 1
Member Since:
July 2, 2021
July 2, 2021
Offline1
July 2, 2021 - 2:05 am
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.
Catalin Bombea
Iasi, Romania
Admin
Forum Posts: 1810
Member Since:
November 8, 2013
November 8, 2013
Offline2
July 2, 2021 - 3:15 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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Brian Pham, Riny van Eekelen
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 205
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
stuart burge
Bruce Tang Nian
Scot C
Othman AL MUTAIRI
Misael Gutierrez Sr.
Attif Ihsan
Kieran Fee
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Forum Stats:
Groups: 3
Forums: 24
Topics: 6223
Posts: 27295
Member Stats:
Guest Posters: 49
Members: 31920
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —