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
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
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
>
Thanks Juan, that does the job nicely!
Jonathan
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
>
Thanks Jim, that's even better than Juan's tip as it doesn't take an extra column.
Jonathan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks