+ Reply to Thread
Results 1 to 5 of 5

Check for doubled-up figures

  1. #1
    Registered User
    Join Date
    12-01-2004
    Location
    Westland, New Zealand
    Posts
    57

    Check for doubled-up figures

    How can I run a check on a column of figures to make sure that I haven't doubled-up any of them? In other words, each number is only allowed to be entered once, so if any of them appear more than once, I want to be notified at the bottom.

    Jonathan

  2. #2
    Juan Pablo González
    Guest

    Re: Check for doubled-up figures

    Put this formula next to the numbers

    =COUNTIF(A:A, A2)=1

    assuming your data is in column A, and starts in A2.

    It will return TRUE for each unique number, or FALSE for each item that is
    repeated.

    --
    Regards,

    Juan Pablo González
    Excel MVP

    "Jonibenj" <[email protected]> wrote in
    message news:[email protected]...
    >
    > How can I run a check on a column of figures to make sure that I haven't
    > doubled-up any of them? In other words, each number is only allowed to
    > be entered once, so if any of them appear more than once, I want to be
    > notified at the bottom.
    >
    > Jonathan
    >
    >
    > --
    > Jonibenj
    > ------------------------------------------------------------------------
    > Jonibenj's Profile:
    > http://www.excelforum.com/member.php...o&userid=17048
    > View this thread: http://www.excelforum.com/showthread...hreadid=469063
    >




  3. #3
    Registered User
    Join Date
    12-01-2004
    Location
    Westland, New Zealand
    Posts
    57
    Thanks Juan, that does the job nicely!

    Jonathan

  4. #4
    Jim May
    Guest

    Re: Check for doubled-up figures

    Use conditional formatting;
    Click on Column Header A,
    Format, Conditional Formatting,
    Select "FormulaIs" and enter:
    =COUNTIF($A:$A,A1)>1
    Select Shade Yellow, say
    OK out...
    HTH

    "Jonibenj" <[email protected]> wrote in
    message news:[email protected]...
    >
    > How can I run a check on a column of figures to make sure that I haven't
    > doubled-up any of them? In other words, each number is only allowed to
    > be entered once, so if any of them appear more than once, I want to be
    > notified at the bottom.
    >
    > Jonathan
    >
    >
    > --
    > Jonibenj
    > ------------------------------------------------------------------------
    > Jonibenj's Profile:
    > http://www.excelforum.com/member.php...o&userid=17048
    > View this thread: http://www.excelforum.com/showthread...hreadid=469063
    >




  5. #5
    Registered User
    Join Date
    12-01-2004
    Location
    Westland, New Zealand
    Posts
    57
    Thanks Jim, that's even better than Juan's tip as it doesn't take an extra column.

    Jonathan

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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