Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: double numbers

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there any way to see all the double numbers (not unique) in a colum (18000 rows)?

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-05-11 14:15, thijs wrote:
    Is there any way to see all the double numbers (not unique) in a colum (18000 rows)?
    You could Cond Format the range using the formula as in

    =COUNTIF($A$1:$A$18000,A1)>1

    and choosing a background color.



    [ This Message was edited by: Aladin Akyurek on 2002-05-11 14:19 ]

  3. #3
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hello

    You can use conditional formatting.
    in the formula is put the following
    =if(countif($a$1:$a$18000,a1)>1,true,false)

    and all the double cells will be formatted as you wish

    Hope that helps



    _________________
    Best Regards,
    Andreas

    [ This Message was edited by: sen_edp on 2002-05-11 16:42 ]

  4. #4
    New Member
    Join Date
    May 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Please tell me more, because as newbie i still don't know how to do this.

    Thijs
    On 2002-05-11 14:25, sen_edp wrote:
    hello

    You can use conditional formatting.
    in the formula is put the following
    =if(countif($a$1:$a$18000,a1)>1,true,false)

    and all the double cells will be formatted as you wish

    Hope that helps



    _________________
    Best Regards,
    Andreas

    [ This Message was edited by: sen_edp on 2002-05-11 16:42 ]

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    Thijs,

    Zo moeilijk is het ook weer niet.

    Lets say that you want to hilite non-unique itemms in A1:A100.

    Select A1:A100.
    Activate the option Format|Conditional Formatting.
    Select Formula is for Condition 1.
    Enter as formula in the empty box:

    =COUNTIF($A$1:$A$100,A1)>1

    Activate the Format button.
    Activate Patterns tab.
    Select color red.
    Activate OK, OK.

    You're done.

  6. #6
    New Member
    Join Date
    May 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin,

    Where can I find in the dutch version of Excel:

    Format|Conditional Formatting.

    (really a newbie, or a dummy who needs help???)

    Thanks


    On 2002-05-12 05:29, Aladin Akyurek wrote:
    Thijs,

    Zo moeilijk is het ook weer niet.

    Lets say that you want to hilite non-unique itemms in A1:A100.

    Select A1:A100.
    Activate the option Format|Conditional Formatting.
    Select Formula is for Condition 1.
    Enter as formula in the empty box:

    =COUNTIF($A$1:$A$100,A1)>1

    Activate the Format button.
    Activate Patterns tab.
    Select color red.
    Activate OK, OK.

    You're done.

  7. #7
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default



    Where can I find in the dutch version of Excel:

    Format|Conditional Formatting.


    Opmaak|Voorwaardelijk..

    Download

    HelpIDs.exe (associated with Ron de Bruin)

    at

    http://www.j-walk.com/ss/excel/tips/tip89.htm


  8. #8
    New Member
    Join Date
    May 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    And.......YES there is still hope for dummy's.
    It works perfect.
    Thanks a lot. You where very helpfull.

    Thijs

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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