+ Reply to Thread
Results 1 to 2 of 2

Remove duplicates from array and count number of values

  1. #1
    Registered User
    Join Date
    12-23-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    14

    Remove duplicates from array and count number of values

    ***The array called NewValuesBM I need to remove the duplicate values inside it and then count how many values are left. That number needs to go on a worksheet called "SUMMARY" in cell B38. Thanks in advance!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Remove duplicates from array and count number of values

    As you have been told on most of your posts, which you never respond to, you should submit an example worksheet . To be honest, I don't know why I even bothered to answer this for you.

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.

+ 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. Replies: 1
    Last Post: 03-21-2015, 02:47 PM
  2. [SOLVED] Count duplicates,then remove them as they are entered
    By 4evra in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-29-2013, 03:12 PM
  3. [SOLVED] Remove duplicates and sort array
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 10-11-2012, 10:22 AM
  4. Remove duplicates and count their number - faster method needed
    By ciprian in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-02-2011, 08:24 AM
  5. Remove duplicates from 1 dimensional array in VBA
    By zaphodb2003 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-08-2010, 04:18 AM
  6. Remove duplicates from one dimensional array
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-29-2010, 05:09 AM
  7. Duplicates! Count, Remove, Highight, etc...
    By ImpetuousRacer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-21-2007, 03:02 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