+ Reply to Thread
Results 1 to 4 of 4

How to extract all filtered results into cells?

  1. #1
    Forum Contributor
    Join Date
    MS-Off Ver

    How to extract all filtered results into cells?

    When you use 'Filter' it shows all records available.


    How can I extract these values in filter into 1 column?

    Expected output:

    Adams Wholesale
    AMB Foods

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    MS-Off Ver
    365(PC) V:2202

    Re: How to extract all filtered results into cells?

    as you have a filter already its safe to assume all these values are already in a column. I am guessing you just want to remove duplicates. Lets assume your values are in column A. copy column A and paste into another column. Highlight that column and then go to the DATA ribbon at the top. Select Remove Duplicates. This will give you all the unique values you are looking for.
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

  3. #3
    Forum Guru
    Join Date
    MS-Off Ver

    Re: How to extract all filtered results into cells?

    Another way using ADVANCED FILTER (assuming your data has a header).
    Select your data including header, go to Data Tab>Advanced
    This opens the advanced filter window.

    Enter the first cell in which you wish to copy your data to (i.e. $D$1), and check "Unique Records Only."
    Hit Okay and your unique values will be copied to column D.
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Forum Guru
    Join Date
    MS-Off Ver
    Microsoft 365 aka Office 365

    Re: How to extract all filtered results into cells?

    Hi Eduards,

    I agree with ChemistB. Advanced Filter is a tool that can be used either manually or using VBA to extract Unique Values from a Table of Data with or without 'AutoFilter' being on.

    See the attached VBA code in Ordinary Code module ModAdvancedFilter which is included in the attached sample file. There is also a 'Standalone' version of the code in the attached file.
    Please Login or Register  to view this content.
    To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). https://www.excel-easy.com/vba/examp...-explicit.html

    o enable Macros and to Run Macros see the following:
    If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.

    To access Visual Basic (VBA) see:
    a. Click on any cell in the Excel Spreadsheet (may not be needed).
    b. ALT-F11 to get to VBA.
    c. CTRL-R to get project explorer (if it isn't already showing).
    d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module.

    Last edited by LJMetzger; 02-26-2020 at 09:58 AM.

+ 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. Using offset to select cells ignoring filtered results
    By peterchclarke in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2019, 01:10 PM
  2. Replies: 1
    Last Post: 09-27-2019, 04:32 PM
  3. Histogram on filtered table, results only on filtered rows
    By Cheesecube in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 03-25-2018, 03:54 AM
  4. Replies: 3
    Last Post: 05-07-2017, 02:53 PM
  5. Extract Cell Results for all Cells with Certain Values
    By Baron100 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-31-2016, 05:13 AM
  6. [SOLVED] Linking cells to filtered results in a separate worksheet
    By excelgreg in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 08-19-2013, 10:47 AM
  7. SUM of filtered results
    By bealy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-25-2009, 12:33 AM


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