Results 1 to 9 of 9
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Check for certain duplicates but not all

    HelloI know that the CountIf has a range and criteria parameters but it does not seem to let me use them.For example I want to find duplicates in the range of 2 to 50 but exclude any letters.I have a data set that has numbers and letters. The numbers are from 2 to 50. The letters are C O T L and PI have a range with all the possible entries and I chose the range with the numbers only as the 2nd argumentBut unfortunately no dice. Any ideasWassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Wassim,

    I'm not entirely sure what you are trying to accomplish. However, if all you want to do is find which values are replicated you can use a pivot table to accomplish this using Count.
    Pivot.JPG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post
    Thanks RetiredGeekIn a nut shell which is what I was supposed to do in the first place:I want to find duplicates in a column but not all duplicates.I want to find if I have 13 duplicated but I don't want to show if I have more than1 "O".Oh by the way this is obviously in a range so if I have dups of any number then flag it but letters are ok to be duped.Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    I don't fully understand what you want, but here's a stab at it in the attached.
    I created a separate column by using only the numbers then conditional formatting to flag those in col A where the dups were in the numbers in col B. Is that what you meant?

    /Kevin
    Attached Files Attached Files

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post
    I am sorry Kweaver

    I hope that I have made my question clearer by using this workbook as an example.

    Please let me know if it is still not clear.

    Sorry I had attached the wrong file but now its is the right one.

    Wassim
    Attached Files Attached Files
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Maybe this is it???
    Attached Files Attached Files
    Last edited by kweaver; 2012-08-11 at 18:19.

  7. The Following User Says Thank You to kweaver For This Useful Post:

    Wassim (2012-08-11)

  8. #7
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Wassim,

    Maybe this is what you're after?
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  9. #8
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post
    Thanks Kweaver

    This did the trick. I was trying to use a range of exclusions but an If/And will work just fine.

    Thanks again

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  10. #9
    New Lounger
    Join Date
    Dec 2009
    Location
    Toronto, Ontario, Canada
    Posts
    7
    Thanks
    0
    Thanked 1 Time in 1 Post

    Cool An Educational Solution

    Thanks everyone! - Neat and instructive. (Stumbled upon this via Windows Secrets Lounge. )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •