Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if a value is found twice in a range
Hello,
I have to check if a value is found twice in a range and display an error if Yes. Lets suppose a range B3:B29 composed of several values not sorted (for ex : 250,412,359,1,6,8,45,18,412). As 412 is found already in second position (and last one) I would like to change color of Cell B30 from nothing to Red. Of course could be 18 which appearing twice or more or any other number... Thanks for you help and creativity !!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if a value is found twice in a range (with no macros !)
I forgot to say that macros are not welcome... cause of security rules.
Sorry ! Hello, I have to check if a value is found twice in a range and display an error if Yes. Lets suppose a range B3:B29 composed of several values not sorted (for ex : 250,412,359,1,6,8,45,18,412). As 412 is found already in second position (and last one) I would like to change color of Cell B30 from nothing to Red. Of course could be 18 which appearing twice or more or any other number... Thanks for you help and creativity !!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if a value is found twice in a range (with no macros !)
If there is data in rows a1:a10, put this formula into conditional
formatting for cell a1 then use the format painter to copy the conditional formatting throughout the range of data. (Formatconditional formatting ) =COUNTIF($A$1:$A$10,A1)1 "François" wrote in message ... I forgot to say that macros are not welcome... cause of security rules. Sorry ! Hello, I have to check if a value is found twice in a range and display an error if Yes. Lets suppose a range B3:B29 composed of several values not sorted (for ex : 250,412,359,1,6,8,45,18,412). As 412 is found already in second position (and last one) I would like to change color of Cell B30 from nothing to Red. Of course could be 18 which appearing twice or more or any other number... Thanks for you help and creativity !!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if a value is found twice in a range
On Fri, 13 May 2005 01:12:03 -0700, François
wrote: Hello, I have to check if a value is found twice in a range and display an error if Yes. Lets suppose a range B3:B29 composed of several values not sorted (for ex : 250,412,359,1,6,8,45,18,412). As 412 is found already in second position (and last one) I would like to change color of Cell B30 from nothing to Red. Of course could be 18 which appearing twice or more or any other number... Thanks for you help and creativity !!! In Cell B3: Format/Conditional Formatting/Formula Is: =COUNTIF($B$3:B3,B3)1 Then format to taste. Then, using the Format Painter, copy that format down as far as is necessary. (Alternatively, select B3:Bn before typing in the above formula). --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 *.xlsx could not be found. Check ... Sequential ERROR screens | Excel Discussion (Misc queries) | |||
Sum vales found with a date range. | Excel Discussion (Misc queries) | |||
Validation error: Says range not found and it is there? | Excel Discussion (Misc queries) | |||
lookup in a range then vlookup from the found value onwards | Excel Programming | |||
Range Name Found?? | Excel Programming |