+ Reply to Thread
Results 1 to 4 of 4

How to extract all filtered results into cells?

  1. #1
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    How to extract all filtered results into cells?

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

    Filter.jpg

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

    Expected output:

    3663
    Adams Wholesale
    Alpine
    AMB Foods
    etc...

  2. #2
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Agawam, MA
    MS-Off Ver
    Microsoft Office 365
    Posts
    843

    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
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    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.
    ChemistB
    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
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,860

    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:
    http://office.microsoft.com/en-us/ex...010031071.aspx
    http://office.microsoft.com/en-us/ex...010014113.aspx
    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:
    http://www.ablebits.com/office-addin...a-macro-excel/
    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.

    Lewis
    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

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