+ Reply to Thread
Results 1 to 4 of 4

advanced filter (VBA) - copy to range in frequency order

  1. #1
    Forum Contributor
    Join Date
    03-05-2015
    Location
    norwich
    MS-Off Ver
    365
    Posts
    107

    advanced filter (VBA) - copy to range in frequency order

    Hi all,

    Wondering if the following is possible. I have data in column C that has multiple duplicates, the advanced filter is fantastic for quickly extracting unique values which I've only just discovered.

    My question is: Can you copy to range in the frequency order that those duplicates happen without disturbing the orginal data?

    i.e if a string occured 3 times in column C this value would be pasted above anything that occured twice or once? Simple code below.


    Please Login or Register  to view this content.
    Thanks for any help!

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,352

    Re: advanced filter (VBA) - copy to range in frequency order

    If you add a column of formulas to do the count - not sure if you have a header of not with your data set - I assumed Yes
    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Contributor
    Join Date
    03-05-2015
    Location
    norwich
    MS-Off Ver
    365
    Posts
    107

    Re: advanced filter (VBA) - copy to range in frequency order

    You assumed correct.

    You absolute hero! Worked like a charm. I just had to change

    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    Thank you, you've saved me ALOT of time

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,352

    Re: advanced filter (VBA) - copy to range in frequency order

    Oops - good catch. That's what I get for just typing, not testing!

+ 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. [SOLVED] Advanced Filter Code : Criteria Range More Than 1 Row Breaks Filter
    By PaulGW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2021, 04:30 PM
  2. [SOLVED] Advanced filter copy to dynamic range?
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-30-2017, 02:54 PM
  3. VBA Advanced Filter - Two Filters Without Deleting Bottom Filter Data In Same Column Range
    By hysterical.useless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2017, 02:54 PM
  4. Replies: 0
    Last Post: 03-06-2017, 03:55 PM
  5. Excel vba - copy an advanced filter range then transpose function
    By Jonno1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2015, 01:27 PM
  6. advanced filter - button to re apply advanced filter across multiple sheets
    By motmac87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 11:16 PM
  7. advanced filter a range:Advanced Filter function
    By Il Principe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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