Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
Hi
Does anyone know a formula that can find "doubles" in the list? For example a list of thousands surnames. I want to check if theya re not repeated.. Thank you in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
For example if the names are in column A then use conditional formatting, for
A1 use: =COUNTIF($A:$A,A1)1 and set the format to bold. Once entered, copy the format in A1 all the way down. -- Gary''s Student "Anna" wrote: Hi Does anyone know a formula that can find "doubles" in the list? For example a list of thousands surnames. I want to check if theya re not repeated.. Thank you in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
Thank you for help, but tI get the message "erroe in the formula" when I am
in the first raw conditional formatting. What is wrong? "Gary''s Student" wrote: For example if the names are in column A then use conditional formatting, for A1 use: =COUNTIF($A:$A,A1)1 and set the format to bold. Once entered, copy the format in A1 all the way down. -- Gary''s Student "Anna" wrote: Hi Does anyone know a formula that can find "doubles" in the list? For example a list of thousands surnames. I want to check if theya re not repeated.. Thank you in advance! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
Thank you but I get the message "error in the formula" as I am in the first
raw conditional formatting.. Whoat is wrong? "Gary''s Student" wrote: For example if the names are in column A then use conditional formatting, for A1 use: =COUNTIF($A:$A,A1)1 and set the format to bold. Once entered, copy the format in A1 all the way down. -- Gary''s Student "Anna" wrote: Hi Does anyone know a formula that can find "doubles" in the list? For example a list of thousands surnames. I want to check if theya re not repeated.. Thank you in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |