an excel formula

[ba2007ali]

<!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--><!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1863"/> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1"/> </o:shapelayout></xml><![endif]--> Hi Sirs,

please can any one help me out, I need to get an excel formula that can give a result as in the below table. That's any numbers gets repeated the result is "Yes" and if not repeated the result is "No":
<table dir="RTL" border="0" cellpadding="0" cellspacing="0" width="128"><col style="width:48pt" span="2" width="64"> <tbody><tr style="mso-height-source:userset;height:24.0pt" height="32"> <td class="xl27" dir="LTR" style="height:24.0pt;width:48pt" height="32" width="64"> Result</td> <td class="xl27" dir="LTR" style="width:48pt" width="64">Number</td> </tr> <tr style="mso-height-source:userset;height:24.0pt" height="32"> <td class="xl27" dir="LTR" style="height:24.0pt;border-top:none" height="32">No</td> <td class="xl27" dir="LTR" style="border-top:none">1</td> </tr> <tr style="mso-height-source:userset;height:24.0pt" height="32"> <td class="xl27" dir="LTR" style="height:24.0pt;border-top:none" height="32">Yes</td> <td class="xl27" dir="LTR" style="border-top:none">2</td> </tr> <tr style="mso-height-source:userset;height:24.0pt" height="32"> <td class="xl27" dir="LTR" style="height:24.0pt;border-top:none" height="32">No</td> <td class="xl27" dir="LTR" style="border-top:none">3</td> </tr> <tr style="mso-height-source:userset;height:24.0pt" height="32"> <td class="xl27" dir="LTR" style="height:24.0pt;border-top: none;width:48pt" height="32" width="64">Yes</td> <td class="xl27" dir="LTR" style="border-top:none">2</td> </tr> <tr style="mso-height-source:userset;height:24.0pt" height="32"> <td class="xl27" dir="LTR" style="height:24.0pt;border-top:none" height="32">Yes
</td> <td class="xl27" dir="LTR" style="border-top:none">2</td> </tr> </tbody></table>



Thanks,
Maher

 

[villy]

Try:
=IF(COUNTIF(A$1:A$13,A1)>1,"YES","NO") 'Change range to suit

 

[RomulusMilea]

Try this, put below formula in cell B1 (assuming the input range is A1:A5):

=IF(COUNTIF($A$1:$A$5,A1)>1,"Yes","No")

Please confirm this solution solves your problem, as expected. Thank you.

Romulus.

 

[ba2007ali]

Thank YOU very much, it worked perfectly
I do appreciate
Maher