+ Reply to Thread
Results 1 to 2 of 2

Formula or Method to Pull list of items based on a Group?

  1. #1
    Registered User
    Join Date
    12-04-2019
    Location
    London, England
    MS-Off Ver
    365
    Posts
    1

    Formula or Method to Pull list of items based on a Group?

    Hi,

    I need to Excel help with how to pull a list of e.g. Airline Carriers from a list of Airports with the data laid out horizontally. The raw data is originally from a pivot table linking to a server.

    Any help would be great!

    Thanks

    example.png

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Formula or Method to Pull list of items based on a Group?

    I don't think this is viable via a formula.
    There is no indication of when the text in column A changes from being an airport to a carrier (and back to an airport for that matter).
    You should be able to achieve this via VBA if ALL the airports are in bold.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to pull from list based on date
    By awascholl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-06-2019, 06:00 PM
  2. Array Formula to Pull List Based on Date - #NUM! Error
    By wooshoe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-30-2019, 08:41 AM
  3. Replies: 12
    Last Post: 04-01-2016, 03:57 PM
  4. Need to pull items from a list to another tab
    By gaitkeeper in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2014, 02:28 PM
  5. formula to get list of items from 1 col based on a criteria in another col
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-31-2009, 08:25 AM
  6. How to count and group items in a list depending on size of list?
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2006, 07:20 PM
  7. How to count items in a list and group depending on size of list?
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-27-2006, 07:14 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1