Results 1 to 7 of 7

Thread: FILTER and extract a column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-15-2025, 07:15 AM #1
    Paul_Hossler
    Paul_Hossler is offline
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,864
    Location

    FILTER and extract a column

    I'm still trying to learn Tables and some of the new 365 functions

    I have FILTER sort of sorted out, but I want to pull selected column(s) from the FILTERed range into another dynamic range

    Attached is sample table, the results of FILTER based on entered value (Green), and a column number entered (Yellow)

    I'd like to just a dynamic array in the Blue

    Capture.JPG

    Thanks
    Attached Files Attached Files
    Last edited by Aussiebear; 04-15-2025 at 12:13 PM.
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules