+ Reply to Thread
Results 1 to 4 of 4

count duplicates items in specific column up to 90000 items

  1. 09-14-2021, 11:25 AM #1
    Alaa-A
    Alaa-A is offline
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    284

    count duplicates items in specific column up to 90000 items

    hi
    I have about more than 90000 duplicate items in COL A. I would show the repeated items and count how many time repeat in COL B,C
    now in this file I have more than 50000 items .
    thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-14-2021, 12:39 PM #2
    Artik
    Artik is offline
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,291

    Re: count duplicates items in specific column up to 90000 items

    I'm not sure if that's what you meant: 
    Please Login or Register  to view this content.
    Artik
    Reply With QuoteRegister To Reply
  3. 09-14-2021, 01:04 PM #3
    Alaa-A
    Alaa-A is offline
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    284

    Re: count duplicates items in specific column up to 90000 items

    that's great !
    yes this is what I want .just question I have no experience in vba , but I do not see in your code using array with dictionary . this is best choice when have a huge data . it makes more fast .
    thanks
    Reply With QuoteRegister To Reply
  4. 09-14-2021, 09:41 PM #4
    Artik
    Artik is offline
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,291

    Re: count duplicates items in specific column up to 90000 items

    Quote Originally Posted by Alaa-A View Post
    just question I have no experience in vba , but I do not see in your code using array with dictionary
    The Items and Keys properties return arrays.
    You can find a very good tutorial on the Dictionary by Paul Kelly here.

    Artik
    Last edited by Artik; 09-14-2021 at 09:43 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count of line items (Unique one, which is extracted after removing duplicates) from column
    By Expert_View in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-30-2021, 04:16 AM
  2. How to count # of items followed by a specific value in a column?
    By mlevin77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2015, 06:01 AM
  3. [SOLVED] Need to count items in column that match multiple data items
    By bclucas55 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2014, 10:03 AM
  4. [SOLVED] VBA copies rows based on specific items in a column but need to rename items created
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2013, 11:38 PM
  5. Count Total of items in a column w/o counting duplicates or blanks
    By Clairebear4 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-23-2013, 10:56 PM
  6. Ascending count of same items in a column containing multiple items
    By kelvi43 in forum Excel General
    Replies: 3
    Last Post: 01-21-2010, 06:58 AM
  7. [SOLVED] Count number of unique items in a column that contains duplicates
    By Steembeem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2005, 09:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1