+ 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
    MS Office Excel 2007
    Posts
    6,949

    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)

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