+ Reply to Thread
Results 1 to 13 of 13

vba countif duplicated the values for two columns

  1. #1
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    vba countif duplicated the values for two columns

    hello
    i appreciate anybody help about find code to count duplicated for 4 columns because i have about 13000 rows contain data i have columns a,b,c,d contain values i would fill in column e the values repeated and column f how many times every value repeated
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,820

    Re: vba countif duplicated the values for two columns

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: vba countif duplicated the values for two columns

    your code works perfect do me faver , please the code is so slow i know my dada is huge if is any way to make quick i will appreciate you

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,820

    Re: vba countif duplicated the values for two columns

    See if this is any faster.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: vba countif duplicated the values for two columns

    it is still slow but better than the first

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,820

    Re: vba countif duplicated the values for two columns

    That's the best I can do, sorry. You might want to post the macro in a new thread and see if anyone else might have a faster approach. If you find something faster, please send me a private message with a link to your new thread. I would like to see the other solution.

  7. #7
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: vba countif duplicated the values for two columns

    no problem if i got it i will provide you thanks so much for this assistance

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,820

    Re: vba countif duplicated the values for two columns

    My pleasure.

  9. #9
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: vba countif duplicated the values for two columns

    don't know but may be this is faster

    Please Login or Register  to view this content.

  10. #10
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: vba countif duplicated the values for two columns

    Another option
    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: vba countif duplicated the values for two columns

    thanks gue2013 your code is good but the most best code is Fluff is quick thanks fluff and thanks everybody provide the code

  12. #12
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: vba countif duplicated the values for two columns

    You're welcome & thanks for the feedback

  13. #13
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: vba countif duplicated the values for two columns

    yes runs 3x faster than mine - really good

+ 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] Create and sum values from columns (from duplicated headers)
    By JoonCB in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-02-2019, 01:31 PM
  2. SUMIF & COUNTIF - Without Duplicated Values
    By xaviersun in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-22-2015, 09:20 AM
  3. Using =SUMIF,=COUNTIF, and =AVERAGE to find specific values in columns
    By ExcelNub83 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2015, 07:53 PM
  4. [SOLVED] count unique values in 3 columns, but countif function not working?
    By frustrated with exce in forum Excel General
    Replies: 3
    Last Post: 06-13-2012, 11:13 AM
  5. Using Countif to return un-duplicated instances
    By dforte in forum Excel General
    Replies: 8
    Last Post: 11-19-2010, 09:07 PM
  6. COUNTIF to match criteria values from 2 columns
    By Zyphon in forum Excel General
    Replies: 4
    Last Post: 09-22-2009, 05:27 AM
  7. [SOLVED] Using COUNTIF to check values in multiple columns
    By DTomSimpson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2005, 12:06 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